![]() |
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| One doubt | namishtiwari | Shell Programming and Scripting | 2 | 06-30-2008 02:23 AM |
| doubt in awk | jisha | Shell Programming and Scripting | 4 | 04-16-2008 04:02 AM |
| AWK doubt | Rafael.Buria | Shell Programming and Scripting | 2 | 02-06-2008 11:00 AM |
| doubt in sed | matrixmadhan | UNIX for Dummies Questions & Answers | 3 | 08-03-2005 11:34 AM |
| doubt it sed | esham | Shell Programming and Scripting | 2 | 03-08-2005 01:52 AM |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
||||
|
Hi All,
I have two files as given below: fileA 1234|aaaaa|vvvv 2222|bbbbbb|cbxxbjh 3333|cccc|jhjhj fileB 3434|bbbcc|cbxxbjh 1234|cat|bullet 3333|cccc|jhjhj I need a script that reads the first column from fileA (i.e 1234) and searches in fileB in the first parameter(i.e first column), if match found ( for example 1234 - line1 in fileA and 1234 - line 2 in fileB), then append the rest of the row in file and write to a new file Example Get first parameter in first row in fileA = 1234 search for the line with first parameter as 1234 in fileB.We get line 2. write 1234|aaaaa|vvvv|cat|bullet to fileC. Thanks in advance JS |
|
||||
|
I have been trying with this command
awk 'NR==FNR{_[NR]=$0;next;}{$1=_[FNR];print}' file1 file2 but i donot know how exactly this works. And it is printing only fileA rows. i don know where to tune it. |
|
||||
|
Please don't bump up questions, read the rules.
Try this: Code:
awk -F"|" 'NR==FNR{a[$1]=$2"|"$3;next}
a[$1]{print $0"|"a[$1];next}1' fileB fileA
|
| Sponsored Links | ||
|
|