Shell Programming and Scripting

Hi Devaraj,

It did not work...there is some syntax error.....I copied it from console so full error message is not appearing here but I tried many time and tried to modify as well but no clue...

https://www.unix.com/shell-programmin...#post302298986 Should get you started. If you follow the basic logic, the script loads the files into an array and dumps it back out again.


You will need to modify the script.

Did you try using nawk?

Thanks...

I am using the following...you have to guide me a bit on this....

awk -F "|" '{print $1}' file1|xargs -i grep {} file2|awk '{print$1}' file2

say file1 is:
12345,X,Y
file2 is:
12345,TEST1

I am doing a comparision on column1....if matches print file1...how can I modify this command to get file1 and then the second column of matched record.....for the above example....12345,X,Y,TEST1

Please help me in fixing the following command:

awk -F "|" 'FNR==NR {a[$1]++; next} {print $0,a[$1]}' file1 file2 >>file3

File1
3308100100|C|20.83|21.87|22.91|04/APR/2009|2009|02|MAR
0102110500|C|5.01|5.26|5.51|04/APR/2009|2009|02|MAR
3308100100|C|18.74|19.67|20.61|04/APR/2009|2009|02|MAR
0102140200|C|5.07|5.32|5.57|04/APR/2009|2009|02|MAR
3308100100|C|741.50|778.58|815.65|04/APR/2009|2009|02|MAR
0104100400|C|41.26|43.33|45.39|04/APR/2009|2009|02|MAR
0530100300|C|38.26|40.17|42.08|04/APR/2009|2009|02|MAR

file2
3308100100|Store Inventory Turns Without Gas(FT LEONARD WOOD MS)
0530100300|Total Markdowns(FT BRAGG MS - SOUTH)
4792999900|Productivity(TRAV AFB)

the file3 should be like this:
3308100100|C|20.83|21.87|22.91|04/APR/2009|2009|02|MAR|Store Inventory Turns Without Gas(FT LEONARD WOOD MS)
3308100100|C|18.74|19.67|20.61|04/APR/2009|2009|02|MAR|Store Inventory Turns Without Gas(FT LEONARD WOOD MS)
3308100100|C|741.50|778.58|815.65|04/APR/2009|2009|02|MAR|Store Inventory Turns Without Gas(FT LEONARD WOOD MS)
0530100300|C|38.26|40.17|42.08|04/APR/2009|2009|02|MAR|Total Markdowns(FT BRAGG MS - SOUTH)


you can see comparision is being done on column 1 of both the files...if column1 of file 1 matches with column 1 of file2 then we need to append column 2 of file 2 in the end of matching rows from file1............please let me know if it is possible or not?