Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

using nawk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting using nawk
# 1  
Old 02-08-2011
using nawk
help out with code. two files aaa bbb contains some records..output file xyz should be like this..see below
i/p file:aaa

08350|60521|0000|505|0000|1555|000|NYCMT|Pd_1 |-11878

i/p file: bbb

60521|60510



o/p file :xyz

60510|08350|60521|0000|505|0000|1555|000|NYCMT|Pd_1 |-11878
Last edited by vgersh99; 02-08-2011 at 09:29 AM.. Reason: please use code tags!
# 2  
Old 02-08-2011
Code:
nawk -F'|' 'FNR==NR{f2[$1]=$2;next} $2 in f2 {$1=f2[$2] OFS $1}1' OFS='|' bbb aaa > xyz

# 3  
Old 02-08-2011
It works but..
its also printing record in aaa. like this



output:


Code:
08350|60321|0000|505|0000|1555|000|NYCMT|Pd_1 |-3023.38
60510|08350|60521|0000|505|0000|1555|000|NYCMT|Pd_1 |-11878|

Last edited by vgersh99; 02-08-2011 at 10:31 AM.. Reason: once AGAIN - use code tags!
# 4  
Old 02-08-2011
Quote:
Originally Posted by Diddy
its also printing record in aaa. like this



output:


Code:
08350|60321|0000|505|0000|1555|000|NYCMT|Pd_1 |-3023.38
60510|08350|60521|0000|505|0000|1555|000|NYCMT|Pd_1 |-11878|

Had you given a more representative sample AND a desired output based on this sample, we could have provided a better solution....
Once again - guessing what you're after....
Code:
nawk -F'|' 'FNR==NR{f2[$1]=$2;next} $2 in f2 {$1=f2[$2] OFS $1;print}' OFS='|' bbb aaa > xyz

This User Gave Thanks to vgersh99 For This Post:
Diddy
# 5  
Old 02-08-2011
Code:
awk 'BEGIN{FS=OFS="|"}{a[$1]=$2}NR>FNR && a[$2] {print a[$2],$0}' bbb aaa

This User Gave Thanks to yinyuemi For This Post:
Diddy
# 6  
Old 02-09-2011
thanks Image vgersh99 n yinyuemi
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Nawk Problem - nawk out of space in tostring on

Hi.. i am running nawk scripts on solaris system to get records of file1 not in file2 and find duplicate records in a while with the following scripts -compare nawk 'NR==FNR{a++;next;} !a {print"line"FNR $0}' file1 file2duplicate - nawk '{a++}END{for(i in a){if(a-1)print i,a}}' file1in the middle... (12 Replies)
Discussion started by: Abhiraj Singh
12 Replies

2. Shell Programming and Scripting

Nawk help

I don't know whats wrong with the code here. Its giving double counts. nawk -F# ' { if( match($2, "= ") > 0) num=substr($2,RSTART+2,length($2)-1); if (match($20, "= ") > 0) res=substr($20,RSTART+2,length($20)-1); if(match(num,... (2 Replies)
Discussion started by: jagpreetc
2 Replies

3. Shell Programming and Scripting

help with nawk

hi guys, I am writing a code and have stuck at one point. Inside nawk I am storing my desired variable a, I just need to find if a is present in an external file error.log or not. If yes, print something. grep or for loop not working properly inside nawk. Sample code provided. nawk ' BEGIN... (5 Replies)
Discussion started by: shekhar2010us
5 Replies

4. UNIX for Dummies Questions & Answers

Nawk help!!!

Hi, Please help me I want to filter all messages having a value less than a particular value..Please advice how to use <= in the below red marked script.. Getting the error as no such file or directory for the marked line no. Thanks in advance... Script is as under : read message gawk... (5 Replies)
Discussion started by: vanand420
5 Replies

5. Shell Programming and Scripting

Nesting - two nawk into one nawk

hi people; this is my two awk code: nawk '/cell+-/{r=(NF==8) ? $4FS$5FS$6 : NF==7 ? $4FS$5 : $4 ;c=split(r,rr);for (i=1;i<=c;i++){if(rr != "111111"){printf($3" %d ""\n",(i+3))}}printf("")}' /home/gc_sw/str.txt > /home/gc_sw/predwn.txt nawk -F'*' '{gsub(/ *$/,"")}$0=$1$($NF-2)'... (2 Replies)
Discussion started by: gc_sw
2 Replies

6. Shell Programming and Scripting

nawk help

Hi Gurus, I am using a script as under : read string nawk -v search="$string" ' /a/,/z/ { block = (block ? block ORS : "") $0; } /z/ { if (block ~ search) print block; } ' <File> nawk -v search="$string" ' /b/,/z/ { ... (1 Reply)
Discussion started by: vanand420
1 Replies

7. Shell Programming and Scripting

nawk help

What am I doing wrong here? I get syntax error. I am trying to parse a file looking for the lines with "running" as the first field then print the 5th field, then looking at the 9th field for specific values and writing the whole line to a junk file. nawk '; {if ($1 == "running")... (10 Replies)
Discussion started by: beppler
10 Replies

8. Shell Programming and Scripting

how to access values of awk/nawk variables outside the awk/nawk block?

i'm new to shell scripting and have a problem please help me in the script i have a nawk block which has a variable count nawk{ . . . count=count+1 print count } now i want to access the value of the count variable outside the awk block,like.. s=`expr count / m` (m is... (5 Replies)
Discussion started by: saniya
5 Replies

9. UNIX for Advanced & Expert Users

nawk use

I found a command who prints x lines before and after a line who contain a searched string in a text file. The command is : ------------------- nawk 'c-->0;$0~s{if(b)for(c=b+1;c>1;c--)print r;print;c=a}b{r=$0}' b=2 a=4 s="string" file1 ...where "b" and "a" are the number of lines to print... (2 Replies)
Discussion started by: ctap
2 Replies

10. Shell Programming and Scripting

nawk

Hi, I had this syntax and no matter what I do, I can't get it run. err message: run6: syntax error at line 121 : `(' unexpected I went to line 121 and it's comment out! All the variables passed to nawk are valid. There are two places I suspect have the problem: 1.... (3 Replies)
Discussion started by: whatisthis
3 Replies
Login or Register to Ask a Question