Thread: Append value of a row to subsequent rows

@ghostdog74: That's a nice, short one-liner!

Hi, I have source file where in the data is in the following format. 01,America,0001,AUH 03,F,F ,001,000,012,000 04,F,F ,023,000,012,000 03,F,A ,002,005,012,005,Y 04,F,A ,023,000,012,000,000 03,F,R ,003,007,007,007,Y,002 04,F,R ,023,000,007,002,002,002 03,F,O ,004,000,000,000,Y,003 04,F,O ,023,000,000,000,000 01,EGYPT,0001,AUH 03,F,F ,001,001,012,001,Y 04,F,F ,023,000,012,001,001 01,SPAIN,0001,AUH 03,F,A ,021,000,012,000 04,F,F...

For fun, a Perl option: Code: perl -ple 'if (m/^01/) { $loc = (split /,/)[1] } else { $_ = "$_,$loc" }' file More awk -ishly Perl: Code: perl -F, -plae 'if ($F[0] == '01') { $loc = $F[1] } else { $_ = "$_,$loc" }' file (I like the first version better since it only splits the '01' lines, and in a big file that might amount to a significant difference.)

Code: $ awk -F"," '$1=="01"{s=$2;print;next}{print $0","s}' file 01,America,0001,AUH 03,F,F ,001,000,012,000,America 04,F,F ,023,000,012,000,America 03,F,A ,002,005,012,005,Y,America 04,F,A ,023,000,012,000,000,America 03,F,R ,003,007,007,007,Y,002,America 04,F,R ,023,000,007,002,002,002,America 03,F,O ,004,000,000,000,Y,003,America 04,F,O ,023,000,000,000,000,America...