info in required format from a file

[kam_6]

have a file which is of the format :-

/Ixxxxxx/WORK/HANDOFF;/xxxxxx/WORK/MB_BACKUP;;;\\\\CAICMESF002DATA_GR
P\OPERATIONS\IBBSSPOOLS\HANDOFF\;ACHOFF*;achoff;binary;3;1;ACHOFF.zi
p;0;1;0;

I want to grep all capital and small OFF pattern in a format :-

/Ixxxxxx/WORK/HANDOFF | ACHOFF* | achoff | ACHOFF.zip | ( 12th field ie 1 Or 0 )

I have tried the following command :-
cat filename |grep -i off |awk -F ";" '{print $1,$6,$7,$12}'

but I am not gettin the desired output

[RAC_1]

cat filename |grep -i off |awk -F ";" '{print $1,"|"$6,"|"$7,"|"$NF}'

Anil

[OldSchool]

given the sample you provided, try this:

cat filename | grep -i off | awk -F";" '{OFS="|"; print $1,$6,$7,$11,$12}'

This changes the Output File Separator to "|" and produces:

/xxxxxx/WORK/HANDOFF|ACHOFF*|achoff|ACHOFF.zip|0

Hope this helps.....

[Arturo Galbiati]

you can use only awk:
awk -F; '/OFF/||/off/ {print $1 "|" $6 "|" $7 "|"$NF}' filename

HTH,
Art

[H.Merijn Brand (procura · Accepted solution]

Or switch to perl

# perl -nle'/off/i&&print join"|",(split/;/)[0,5,6,10,11]' filename
/Ixxxxxx/WORK/HANDOFF|ACHOFF*|achoff|ACHOFF.zip|0

or using autosplit

# perl -aF\; -nle'/off/i&&print join"|",@F[0,5,6,10,11]' filename
/Ixxxxxx/WORK/HANDOFF|ACHOFF*|achoff|ACHOFF.zip|0

Enjoy, Have FUN! H.Merijn

[kam_6]

Thanks !!