06-01-2007
Quote:
Originally Posted by bsrajirs
Hi All,
Please help me in creating files through K-shell scripts.
I am having one file in this format.
OWNER.TABLE_NAME
OWNER.TABLE_NAME1
OWNER1.TABLE_NAME
OWNER1.TABLE_NAME1
I want to read the above file and create new file through k shell script.
The new file should looks like this.
SCHEMAS=OWNER,OWNER1
INCLUDE=TABLE:"IN ('TABLE_NAME','TABLE_NAME1')"
Please let me know there are any questions.
Thanks,
bsraj.
Try this. This may not be a generic version.
$ cat file1.ksh
#!/usr/bin/ksh
schemas=$(cut -f1 -d. file1 | sort -u | xargs | sed 's/ /,/')
tables=$(cut -f2 -d. file1 | sort -u | xargs | sed -e 's/ /,/' -e "s/.*/'&/" -e "s/,/','/" -e "s/.*/&'/")
echo "SCHEMAS=$schemas\nINCLUDE=TABLE:\"IN ($tables)\""
$ file1.ksh
SCHEMAS=OWNER,OWNER1
INCLUDE=TABLE:"IN ('TABLE_NAME','TABLE_NAME1')"
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How can i read all the unique words in a file, i used -
cat comment_file.txt | /usr/xpg6/bin/tr -sc 'A-Za-z' '/012'
and
cat comment_file.txt | /usr/xpg6/bin/tr -sdc 'A-Za-z' '/012'
but they didnt worked..... (5 Replies)
Discussion started by: aditya.ece1985
5 Replies
2. Shell Programming and Scripting
Hi,
i need a script to find words "error,jbase,voilation,segmentation" from a file(verify.txt) and if got any of the above words then send an email and if wont find any then execute the cron job. every time it read file verify.txt it must first clear the previous data in the file .
Kindly... (3 Replies)
Discussion started by: Mujtaba khan
3 Replies
3. Shell Programming and Scripting
hi,
I am a begginer in unix and i want to know how to open a file and read it and separate the numbers & words and storing it in separate files, Using shell scripting.
Please help me out for this.
Regards
S.Kamakshi (2 Replies)
Discussion started by: kamakshi s
2 Replies
4. Shell Programming and Scripting
Hi,
I have two files with the format shown below. I need to read first field(value before comma) from file 1 and search for a record in file 2 that has the same value in the field "KEY=" and write the complete record of file 2 with corresponding field 2 of the first file in to result file.
... (11 Replies)
Discussion started by: King Kalyan
11 Replies
5. Programming
Hi
I have a file like that:
1 2 3 4 5 6 7 8
and I want print on stdout:
1 3 8
in other words i want choose what print out.
I was thinking to use fscanf as:
fscanf(file_in,"%d %d %d",&a, &b,&c);
but in this way i get:
1 2 3
Is there a solution using fscanf to obtain my... (2 Replies)
Discussion started by: Dedalus
2 Replies
6. Shell Programming and Scripting
I want to create a egrep variable from a file.
For example:
string=`cat query.txt`
cat myfile.txt | egrep "$string"
The string variable file has a list of one or multiple lines
So the end result of:
cat myfile.txt | egrep "$string"
would be:
cat myfile.txt | egrep... (2 Replies)
Discussion started by: numele
2 Replies
7. Shell Programming and Scripting
Hello,
I have a complex problem. I have a file in which words have been joined together:
Theboy ranslowly
I want to be able to correctly split the words using a lookup file in which all the words occur:
the
boy
ran
slowly
slow
put
child
ly
The lookup file which is meant for look up... (21 Replies)
Discussion started by: gimley
21 Replies
8. Shell Programming and Scripting
Hi,
I am trying to write a shell script which can read folder names from a text file and then go to the folder and picks up a xml file and write on my sipp script so that I can run the sipp script.
For example:
I have a text file called thelist.txt where I have provided all the folders... (7 Replies)
Discussion started by: pm1504
7 Replies
9. Shell Programming and Scripting
Hello Members,
I have one file which contains million of supplier code. I need to load these codes into database 1000 at a time.
Database procedure reads from an external table which is based on the unix files.
All I want to do is to read from the bigger file e.g. MAIN_FILE.txt and create... (1 Reply)
Discussion started by: chetanojha
1 Replies
10. UNIX for Beginners Questions & Answers
hi I made this simple script to extract data and pretty much is a list and would like to extract data of two words separated by commas and I would like to make a new text file that would list these extracted data into a list and each in a new line.
Example that worked for me with text file... (5 Replies)
Discussion started by: dandaryll
5 Replies
LEARN ABOUT DEBIAN
cut-diff
CUT-DIFF(1) Cutter's manual CUT-DIFF(1)
NAME
cut-diff - show difference between 2 files with color
SYNOPSIS
cut-diff [option ...] file1 file2
DESCRIPTION
cut-diff is a diff command that uses diff feature in Cutter. It shows difference with color.
It's recommended that you use a normal diff(1) when you want to use with patch(1) or you don't need color.
OPTIONS
--version
cut-diff shows its own version and exits.
-c [yes|true|no|false|auto], --color=[yes|true|no|false|auto]
If 'yes' or 'true' is specified, cut-diff uses colorized output by escape sequence. If 'no' or 'false' is specified, cut-diff never
use colorized output. If 'auto' or the option is omitted, cut-diff uses colorized output if available.
The default is auto.
-u, --unified
cut-diff uses unified diff format.
--context-lines=LINES
Shows diff context around LINES.
All lines are shown by default. When unified diff format is used, 3 lines are shown by default.
--label=LABEL, -L=LABEL
Uses LABEL as a header label. The first--label option value is used as file1's label and the second --label option value is used
asfile2's label.
Labels are the same as file names by default.
EXIT STATUS
The exit status is 0 for success, non-0 otherwise.
TODO: 0 for non-difference, 1 for difference and non-0 for errors.
EXAMPLE
In the following example, cut-diff shows difference between file1 and file2:
% cut-diff file1 file2
In the following example, cut-diff shows difference between file1 and file2 with unified diff format:
% cut-diff -u file1 file2
SEE ALSO
diff(1)
Cutter February 2011 CUT-DIFF(1)