Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Shell Programming and Scripting

Login to Discuss or Reply to this Discussion in Our Community

 
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 ?
Login or Register to Ask a Question

Previous Thread | Next Thread

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
Login or Register to Ask a Question