AWK help reqd


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting AWK help reqd
# 8  
Old 04-22-2008
please search the forums Smilie

How to correct this error ? - Had been answered many times
# 9  
Old 04-22-2008
Use nawk or /usr/xpg4/bin/awk on Solaris.

Regards
# 10  
Old 04-23-2008
Need some help!

Hi,

Still not able to resolve ;-(

Below are the file details
==============================================
>cat file2
12345678901
98765432101

>cat file1
gsfgfgfgfgfgfgfgfgfg12345678901fgfgfgfgfgfgfgffgfgfsgfdg
gsfgfgfgfgfgfgfgfgfg12345678901fgfgfgfgfgfgfgffgfgfsgfdg
gsfgfgfgfgfgfgfgfgfg34578910204fgfgfgffgfgfggffgfgfsgfdg
==============================================


nawk isn't returning anything while comparing file1 & file2 Smilie
=======================================================
>/usr/bin/nawk 'NR=FNR{a[substr($0,1,11)];next} substr($0,21,31) in a{print}' file2 file1

>awk 'NR=FNR{a[substr($0,1,11)];next} substr($0,21,31) in a{print}' file2 file1
awk: syntax error near line 1
awk: bailing out near line 1
=======================================================


whereis nawk
nawk: /usr/bin/nawk /usr/man/man1/nawk.1

>whereis awk
awk: /usr/bin/awk /usr/man/man1/awk.1


Please Help!
# 11  
Old 04-23-2008
Try this, there was something wrong in the second substr function:

Code:
nawk '
NR=FNR{a[substr($0,1,11)];next}
substr($0,21,11) in a{print}
' file2 file1

Regards
# 12  
Old 04-24-2008
Still no output!!

Hi,

I am still not able to get any matching rows when using 'nawk'. Smilie
Please help me to solve this! Also please let me know to debug this.

>cat file1
gsfgfgfgfgfgfgfgfgfg12345678901fgfgfgfgfgfgfgffgfgfsgfdg
gsfgfgfgfgfgfgfgfgfg12345678901fgfgfgfgfgfgfgffgfgfsgfdg
gsfgfgfgfgfgfgfgfgfg34578910204fgfgfgffgfgfggffgfgfsgfdg

>cat file2
12345678901
98765432101

Below script isn't returning any rows =>
==========================================
>nawk '
> NR=FNR{a[substr($0,1,11)];next}
> substr($0,21,11) in a{print}
> ' file2 file1
==========================================


Thanks
# 13  
Old 04-24-2008
Oh my, I must be accurater:

Code:
awk '
NR==FNR{a[substr($0,1,11)];next}
substr($0,21,11) in a{print}
' file2 file1

Regards
# 14  
Old 04-25-2008
That works gr8!

Thanks a lot!!! Smilie
That works fine.... I need some tips on debugging these, plz send me Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

unable to grep the reqd field

hi all, i have a data sm thg like this 28504 0 abc 148782859 42 101M nhmmmm ilopo abc 2345432 i want to get only the field which is just aftr abc i,e., 148782859, 2345432 i have used grep /abc\t/ filename to get that but its not working can any 1 help me out (5 Replies)
Discussion started by: anurupa777
5 Replies

2. Shell Programming and Scripting

Explanation reqd for the Unix file

Hi, I have a unix file with the following contents #/usr/bin/sh cd /ct/mr/prod/bin ncm_AdjCob.pl -a /ct/mr/prod/wg/applog_AdjDev.log -c /ct/mr/prod/lib/config/bcmp_AdjDevCob.conf -s /ct/mr/prod/log/syslog can anyone explain what it says. particularly -a ,-c... (5 Replies)
Discussion started by: psthariharan
5 Replies

3. Shell Programming and Scripting

Help reqd in shell scripting..

Hi guys, I am new to shell scripting and I need urgent assistance. I have an xml like : <AgreementNumberFull>13-WY-84252</AgreementNumberFull> <AgreementNumberAbbr>WY84252</AgreementNumberAbbr> <LineOfBusiness>F</LineOfBusiness> <CompanyCode>0005</CompanyCode> <UniqDigit/> <StateCode/> ... (9 Replies)
Discussion started by: puneetkanchi
9 Replies

4. Shell Programming and Scripting

Explanation reqd

Hi, i have a script of following content #!/usr/bin/sh 'exit 255' USR1 ncm_CheckDir.pl -a /cnt/mgr/test/working/applog_CheckDir.log -c /cnt/mgr/test/lib/config/bp_CheckDir.conf -s /cnt/mgr/test/log/syslog filename : BC_CheckDir when i execute ie : sh BC_CheckDir i am getting... (11 Replies)
Discussion started by: psthariharan
11 Replies

5. Shell Programming and Scripting

Shell Script - help Reqd

Hi, I need someone's help in writing a shell script. Since am very new i am stuck . I have 2 files in the same dir. ============================================== FileA Table1~07/07/2009 00:00:00~4 Table1~07/06/2009 00:00:00~41 Table1~07/08/2009 00:00:00~4 ... (8 Replies)
Discussion started by: vijayarajvp
8 Replies

6. Shell Programming and Scripting

shell script reqd - deleting files

I have written a script that deletes files: Requirement: i need to delete the files and to know how many files are deleted i.e the count of files and even i need to display when the started time of deletion and the ending time of deletion. I need to display these two times. script: ... (2 Replies)
Discussion started by: venkatesht
2 Replies

7. Shell Programming and Scripting

unix shell script reqd...

Task: Short Description: To find the files in a particular directory for the previous day, sort them by date and time and e-mail it across to a particular id. And the time is divided into eight fields and based on the time the respective field should be updated with the flag 1. Eight... (7 Replies)
Discussion started by: venkatesht
7 Replies

8. Shell Programming and Scripting

Checklist for Shell Script reqd

Hi, Can anyone provide me with the Code Review Checklist for Shell scripts ?? Thanks in advance. (2 Replies)
Discussion started by: Shivdatta
2 Replies

9. HP-UX

command reference sheet reqd.

hi everybody, i m AIX guy.... due 2 some reason i was also askd 2 work in HP-UX so i think all d concepts r same as AIX.... so i thought it s easy to learn by comparitve study.... if so then wr can i get the materials???????? thanks in advance........ (1 Reply)
Discussion started by: rrlog
1 Replies

10. HP-UX

Help Reqd

Hi I am facing the problem where my HP Unix system date is in accordance with the current date but the logs written by the same is of previous time stamp. Eg. System Date - Thu Mar 15 18:00:04 IST 2007 Syslogs - Mar 15 12:30:10 mac@1 ftpd: FTP LOGIN FROM xx.xxx.xxx.xx , main The ftp... (1 Reply)
Discussion started by: PradeepRed
1 Replies
Login or Register to Ask a Question