need to create awk sript for generating two files from a file checking a condition

vandana.parwani · 03-03-2010, 07:52 AM

Hi,

I have a csv file like, having HDR segment and multiple LIN01 segment in each line:like

HDR01;INSDES;XOSN;HEL;39;0;LWS21
LIN01;0017064576;000010;R;8000043703;008R12989;1,000;20090727;110504;PORVOON OFFS' ETPAINO OY;14 YRITTÄJÄ' NKATU;;;;PORVOO;06150;Jyrki;Toivola;;2001269538;;LR;;

LIN01;0017064783;000010;R;8000043706;013R00623;1,000;20090727;110507;AUTO-KILTA TRUCKS OY;27 TERMINAALINKATU;;;;LAPPEENRANTA;53420;Tea;Hirvonen;;2002604609;;LF;;

LIN01;0017065490;000010;R;8000043717;641S00098;1,000;20090727;110515;ETELÄ- SAVO'N SAIRAANHOITOPIIRI;35-37 PORRASSALME' NKATU;;;;MIKKELI;50100;sauli;put konen;;2001236683;;LR;;

here i want to split file in two, one having LIN01 segment which have LR at end, and one which have LF at end in LIN01 segment.

is it possible to created awk or shell script for this?

regards,
vandy.

pixellany · 03-03-2010, 08:18 AM

to clarify: Remove the section beginning with "LIN01" and ending with "LF;;" and write that section to a new file.

Easy to do with SED----
Use an address range---eg:
sed '/start/,/stop/ <action>' filename

It could be 2 passes--one to filter out that section and write to a new file, the second to delete the section from the original file. Once you have the basic logic, it may be possible to combine into one statement.

Good SED tutorial here:
http://www.grymoire.com/Unix/Sed.html

ghostdog74 · 03-03-2010, 08:38 AM

Code:

awk '/LIN01.*LR;;/{print $0 > "LIN01LR.txt"}/LIN01.*LF;;/ {print $0 > "LIN01LF.txt"}' file

pixellany · 03-03-2010, 11:15 AM

Code:

sed -i -e '/^LIN01/,/LF;;$/ w newfile' -e '/^LIN01/,/LF;;$/ d' oldfile

I would have thought the one could combine the two commands inside brackets({}), but that is eluding me...