Search Results

If a file has following kind of data, comma delimited

1,2,3,4
1
1
1,2,3,4
1,2
2
2,3,4


My required output must have only 4 columns with comma delimited


1,2,3,4
111,2,3,4...

superb, thanks alot scrutinizer.

sorry, forget about the empty lines.
your awk command is too fast , it just took 4 seconds :) thanks .
i am talking about the Z M4 , Z H4 kind data in file1 ,
because the for loop in the end part...

AAA

BBB
CCC
123
A12
32B
Z H4
M H4

@ SriniShoo SriniShoo
It will not be the case
that will not happen in the real time , so dont consider that scenario

Hi,

file1.txt

AAA
BBB
CCC
DDD

file2.txt

abc|AAA|AAAabcbcs|fnwufnq
bca|nwruqf|AAA|fwfwwefwef
fmimwe|BBB|fnqwufw|wufbqw
wcdbi|CCC|wefnwin|wfwwf
DDD|wabvfav|wqef|fwbwqfwfe

i need...