Shell Programming and Scripting

Hi Guys,

I am having two requirement in one of my scripts. please help out to find a fast solution using AWK (since there is lot of data to be processed)

1) First snippet -

File1 has two columns and file2 has three columns

If any value of column 1 of file1 matches with column 1 of file2 then output file ie file3.csv should have corresponding value of Columns 1 & 2 of file1 with corresponding values of column 3 & 4 of file2.

For eg :

File1.txt

Code:

10000000    |25000000
20000000    |35000000

File2.txt

Code:

10000000    | 0000001.99|R
20000000    | 0000002.99|P

file3.csv

Code:

"10000000    ","25000000"," 0000001.99","R "
"20000000    ","35000000"," 0000002.99","P "

2) Second snippet
Second script should just convert input.txt to output.csv after doing little proccessing as shown below:

input.txt

Code:

10000000    | 0000001.99|R
20000000    | 0000002.99|P

output.csv

Code:

"10000000    "," "," 0000001.99","R "
"20000000    "," "," 0000002.59","P "

(The second column needs to be left blank as shown above ie between " ", so that second column would appear blank while opening in an excel )

Thanks in Advance !!!

Moderator's Comments:

Code tags for code, please.

What have you tried?

I tried using loops, but it is not fast. I am not familiar with AWK. If someone could tell me how to implement it using AWK it would be much helpful

Try:

Code:

awk -F"|" 'NR==FNR{col1[$1]=$1;col2[$1]=$2} NR>FNR && $1 in col1{printf("\"%s\",\"%s\",\"%s\",\"%s\"\n",col1[$1],col2[$1],$1,$2)}' file1 file2

for the first part.

For info on awk go here.Awk - A Tutorial and Introduction - by Bruce Barnett

Hi Chacko193,
The awk you have suggested is working as expected.

Thank you !!