01-03-2008
hi,
Actually i have sql queries and with those queries i want to check the feed files in unix.
so i have the joining condition as:
Column 4 from F1= Column 29 from F2;
Column 10 from F1= Column 165 in F2;
and if value in column 8 from F2='3'
so that i can retrieve the value of column 7(in F2) which i need finally.
now can u help me.?
thanks
10 More Discussions You Might Find Interesting
1. Programming
Hi,
I want to know different ways of suppressing printing of last N lines.
Can anyone help?
Thanks,
Sree (1 Reply)
Discussion started by: chakri400
1 Replies
2. Shell Programming and Scripting
I have this files:
./frm/lf_mt1_cd.Ic_cell_template.attr
./die/addgen_tb_pumd.Ic_cell_template.attr
./min_m1_n.Ic_cell_template.attr
When I use:
awk -F\/ '{print NF}'
Would result to:
3
3
2
I would like to list the files with 3 fields on it. Any Suggestions? (1 Reply)
Discussion started by: jehrome_rando
1 Replies
3. Shell Programming and Scripting
Hi all , i need to grep for a string in a text file and print the string and the 3rd line above it.
As always , Thanks. (4 Replies)
Discussion started by: okiedokie
4 Replies
4. Shell Programming and Scripting
I want to print "Hello,How are you" in green colour using printf. How to do so? (5 Replies)
Discussion started by: proactiveaditya
5 Replies
5. Shell Programming and Scripting
Hi,
We are facing some issues while finding the particular string.
Our file is:
cat 1.txt
Node Name(s)
Preparation fragment
Partition:
Transformation instance:
Transformation:
Applied rows:
Affected rows:
Rejected rows:
Throughput(Rows/Sec):
Throughput(Bytes/Sec):
Last... (3 Replies)
Discussion started by: Amey Joshi
3 Replies
6. Shell Programming and Scripting
Hello all,
I need to print all the lines before a specific string and print a custom message 2 lines after that.
So far I have managed to print everything up the string, inclusively, but I can't figure out how to print the 2 lines after that and the custom message.
My code thus far is:... (4 Replies)
Discussion started by: SEinT
4 Replies
7. Shell Programming and Scripting
Hi,
I need to find the lines which are repeating in a file
cat file1
abcdef 23-1
abcdef 24-1
bcdeff 25-0
ttdcfg 26-0
ttdcfg 20-0
bcdef1 25-0
bcdef2 25-0
bcdef3 25-0
bcdef4 25-0
bcdef4 00-0any help is greatly appreciated. Thanks in advance.
In need to find which one are... (3 Replies)
Discussion started by: jpkumar10
3 Replies
8. Shell Programming and Scripting
Hi !
I need some help with a script I am writing.
I am trying to compare two files, the first file being in this format :
Header1
Text1-1
Text1-2
Text1-3
Header2
Text2-1
etc...
For each header, I want to check if it appears in the second file, and if it is the case print the header... (4 Replies)
Discussion started by: jbi
4 Replies
9. Shell Programming and Scripting
Hello Everyone,
I want to print out the records after and before a certain record. I am able to figure out how to print that particular record but not the ones before and after. Looking for some advice
Thank you (6 Replies)
Discussion started by: danish0909
6 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I have a text file that looks like the following:
ILMN_1343291 6 74341083 74341772
ILMN_1343291 6 74341195 74341099
ILMN_1343295 12 6387581 6387650
ILMN_1651209 1 1657001 1657050
ILMN_1651209 5 83524260 83524309
I... (1 Reply)
Discussion started by: evelibertine
1 Replies
comm(1) General Commands Manual comm(1)
NAME
comm - select or reject lines common to two sorted files
SYNOPSIS
file1 file2
DESCRIPTION
comm reads file1 and file2, which should be ordered in increasing collating sequence (see sort(1) and Environment Variables below), and
produces a three-column output:
Column 1: Lines that appear only in file1,
Column 2: Lines that appear only in file2,
Column 3: Lines that appear in both files.
If is used for file1 or file2, the standard input is used.
Options 1, 2, or 3 suppress printing of the corresponding column. Thus prints only the lines common to the two files; prints only lines in
the first file but not in the second; does nothing useful.
EXTERNAL INFLUENCES
Environment Variables
determines the collating sequence expects from the input files.
determines the language in which messages are displayed.
If is not specified in the environment or is set to the empty string, the value of determines the language in which messages are displayed.
If is not specified in the environment or is set to the empty string, the value of is used as a default. If is not specified or is set to
the empty string, a default of ``C'' (see lang(5)) is used instead of If any internationalization variable contains an invalid setting,
behaves as if all internationalization variables are set to ``C''. See environ(5).
International Code Set Support
Single- and multi-byte character code sets are supported.
EXAMPLES
The following examples assume that and have been ordered in the collating sequence defined by the or environment variable.
Print all lines common to and (in other words, print column 3):
Print all lines that appear in but not in (in other words, print column 1):
Print all lines that appear in but not in (in other words, print column 2):
SEE ALSO
cmp(1), diff(1), sdiff(1), sort(1), uniq(1).
STANDARDS CONFORMANCE
comm(1)