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.