Visit Our UNIX and Linux User Community


Shell Programming and Scripting


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Shell Programming and Scripting
# 15  
Old 02-25-2008
sorry i have given like this only with filenames.but no output.
nivas
# 16  
Old 02-25-2008
it is working for me.

I have created a script 'kanu.awk' with following content

#!/usr/bin/awk -f

NR==FNR { A[$0]=1; next; }
{ if ($1 in A) { print $0 } }

then 'chmod u+x kanu.awk'

and executed this script in the following way

./kanu.awk file1.txt file2.txt

where file1.txt is your lookup file and file2.txt is your data file

This gave me following output.

ERTYUIOU1234567689089767688 resh@abc_com 76763721832832233 893589893499 asdsddssd 200880930`2323232

I don't know what happened in your case. worth double checking your script with mine.
# 17  
Old 02-25-2008
fILE 1 :

ABCEFGHI|0000000000003537
ABCEFGHI|0000000000132807
ZXCVBNML|0000000000132000

FILE 2
Code:
ABCEFGHI0000000000003537   name@yahoo_com                                                                                2008-02-020000823.15 0011676 00017.00 2008-03-01ROJER,TERASA C                                000000000000051.66 000000000000040.00 CBB00010000000906
ABCEFGHI0000000000027601   cat@yahoo_com                                                                                  2008-02-020014243.99 0000758 00284.00 2008-03-01ROJER,  WERASA E                              000000000000016.03 000000000000000.00 CBB00010000000920
ABCEFGHI0000000000116214   taj@yahoo_com                                                                                2008-02-030001935.75 0001064 00056.00 2008-03-02IM,TOM   CRUSE                                000000000000030.74 000000000000020.00 CBB00010000000915
ABCEFGHI0000000000132807   pocketfull@yahoo_com                                                                    2008-02-030000231.67 0002268 00015.00 2008-03-02JACK,LILIA P                                  000000000000003.41 000000000000000.00 CBB00010000000906
ZXCVBNML0000000000132000   pocketfull@yahoo_com                                                                    2008-02-030000231.67 0002268 00015.00 2008-03-02JACK,LILIA P                                  000000000000003.41 000000000000000.00 CBB00010000000906

OUTPUT FILE I NEED TO GET

Code:
ABCEFGHI0000000000003537   name@yahoo_com                                                                                2008-02-020000823.15 0011676 00017.00 2008-03-01ROJER,TERASA C                                000000000000051.66 000000000000040.00 CBB00010000000906
ABCEFGHI0000000000132807   pocketfull@yahoo_com                                                                    2008-02-030000231.67 0002268 00015.00 2008-03-02JACK,LILIA P                                  000000000000003.41 000000000000000.00 CBB00010000000906
ZXCVBNML0000000000132000   pocketfull@yahoo_com                                                                    2008-02-030000231.67 0002268 00015.00 2008-03-02JACK,LILIA P                                  000000000000003.41 000000000000000.00 CBB00010000000906

both file1 and file2 has many records

awk -f ' NR==FNR { A[$0]=1; next; }
{ if ($1 in A) { print $0 } } ' file1 file2 > out.txt

WHEN iam using the above command no output is coming
nivas
# 18  
Old 02-25-2008
sorry command i uses is

awk ' NR==FNR { A[$0]=1; next; }
{ if ($1 in A) { print $0 } } ' file1 file2 > out.txt
nivas
# 19  
Old 02-25-2008
ah what did you tell sometime back ?
you said there is no '|' symbol in the message ...

Quote:
sorry i have made 1 mistake. input files are

file1
ERTYUIOU1234567689089767688
FDHJHKJH6817738971783893499
JFKDKLLUI9080986766433498444
and now you are using file with '|' symbol !!!!!!!

Can you paste here the conect of file1.txt and file2.txt which you actually needed ?
# 20  
Old 02-25-2008
sorry i had confused you....sorry again.


I have made my file1 as

ABCEFGHI0000000000003537
ABCEFGHI0000000000132807
ZXCVBNML0000000000132000

but for small file with file1(5 records)
and file2(9 records)

it is working fine...and i executed this command for 85 thousand records file 1 and file2.. it is not giving any output.
nivas
# 21  
Old 02-25-2008
Quote:
Originally Posted by nivas
it is working fine...and i executed this command for 85 thousand records file 1 and file2.. it is not giving any output.
Does that mean it is coming back to prompt and not displaying anything ?
In that case can you re-check your file format ?

Previous Thread | Next Thread
Test Your Knowledge in Computers #446
Difficulty: Medium
The Large Hadron Collider experiments at CERN run on Scientific Linux.
True or False?

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Shell script to read lines in a text file and filter user data Shell Programming and Scripting

sxsaaas (3 Replies)
Discussion started by: VikrantD
3 Replies

2. Shell Programming and Scripting

shell programming and scripting

hi, i am trying this while loop and i only want that it should only read food as pizza....no other entry should be taken here. #!/usr/bin/perl -w $food = " "; while ( $food ne 'pizza' ) { print 'enter what you had last night: '; chomp ($food = <STDIN>); #print $food ; } ... (2 Replies)
Discussion started by: kullu
2 Replies

3. Shell Programming and Scripting

shell programming and scripting

I was trying out some new series to get it print 1 1 2 1 2 3 1 2 3 4 1 2 3 4 5 and the seond one is 1 2 2 3 3 3 4 4 4 4 5 5 5 5 5 but was unable to get the result. (5 Replies)
Discussion started by: harjinder
5 Replies

4. Shell Programming and Scripting

shell scripting and programming

RCS file: /home/rcap/.APCVS/regs/rc/power/analysis/pow_rtl/renes_setup.g,v Working file: ./power/analysis/pow_rtl/renes_setup.g head: 1.14 branch: locks: strict access list: symbolic names: br_2010_101_200: 1.13.0.12 br_2010_101_100: 1.13.0.10 br_2009_91_200:... (3 Replies)
Discussion started by: harjinder
3 Replies

5. Shell Programming and Scripting

Shell Programming and Scripting

Hi All, How do I code a password with multiple special characters in it. Example: password is P#utar&@ None of the belwo options worked 1. passwd="P#utar&@" 2. passwd='P#utar&@' Any help will be greatly appreciated. (3 Replies)
Discussion started by: afredri
3 Replies

6. Infrastructure Monitoring

Shell Programming and Scripting

# set date to your spec: this is month/day/yr/hr/min/sec: sysdate=`date '+%m/%d/%Y-%H:%M:%S'` # get the last line before the history file is modified tail -1 /tmp/hosthistory.txt |while read lastdate mydevices do echo $lastdate echo $mydevices done LIST = 'ypcat hosts|| sort... (11 Replies)
Discussion started by: lemseffert
11 Replies

7. Shell Programming and Scripting

Shell Programming and Scripting

Hi, Iam having the files as follows: file1 aa aa aa aa ab ac ad ae file2 aa aa ab Outputfile: (20 Replies)
Discussion started by: nivas
20 Replies

8. Shell Programming and Scripting

Shell Programming and Scripting

I want to compare some files. say iam having 2 sets of files ,each is having some 10 files. ie, file1 1a.txt 1b.txt 1c.txt ... file2 2a.txt 2b.txt 2c.txt ... i need to read line by line of this files parralley.. ie.. i want to read file1 first line that is 1a.txt and file2... (2 Replies)
Discussion started by: nivas
2 Replies

9. Shell Programming and Scripting

Shell Programming and Scripting

Hi, iam having the file as follows: ABCDEFGH|0987654321234567 ABCDEFGH|0987654321234523 ABCDEFGH|0987654321234556 ABCDEFGH|0987654321234545 POIUYTRE|1234567890890678 POIUYTRE|1209867757352567 POIUYTRE|5463879088797131 POIUYTRE|5468980091344456 pls provide me the split command ... (14 Replies)
Discussion started by: nivas
14 Replies

Featured Tech Videos