UNIX for Dummies Questions & Answers

Hi,
Below is a single line output.

subsD,01 02 03 04 05 00 00 00 00 07 00 05,hlr,common,00000000 subsD,01 02 03 04 05 00 00 00 00 07 00 05,hlr,01,baoc|notActive|notInduced,activeAndOperative,notActive,notActive,noneDesignated,0,notActive| 00|,notActive|00|,notActive|00|,notActive|00|30|,, subsD,01 02 03 04 05 00 00 00 00 07 00 05,hlr,02,baoc|notActive|notInduced,notActive,notActive,notActive,noneDesignated,0,notActive|00|,notAc tive|00|,notActive|00|,notActive|00|30|,,


In which "01 02 03 04 05 00 00 00 00 07 00 05" get repeat 3 time in a line.
I need a output which should be like this:

subsD,01 02 03 04 05 00 00 00 00 07 00 05,hlr,common,00000000 subsD,,hlr,01,baoc|notActive|notInduced,activeAndOperative,notActive,notActive,noneDesignated,0,notA ctive|00|,notActive|00|,notActive|00|,notActive|00|30|,, subsD,,hlr,02,baoc|notActive|notInduced,notActive,notActive,notActive,noneDesignated,0,notActive|00| ,notActive|00|,notActive|00|,notActive|00|30|,,

in a single line output.

Thanks for support.

Assuming that it is always the same fields that have to be replaced:

Code:

awk -F"," '{sub(/.*/,"",$6); sub(/.*/,"",$21); print}' OFS="," infile
subsD,01 02 03 04 05 00 00 00 00 07 00 05,hlr,common,00000000 subsD,,hlr,01,baoc|notActive|notInduced,activeAndOperative,notActive,notActive,noneDesignated,0,notActive| 00|,notActive|00|,notActive|00|,notActive|00|30|,, subsD,,hlr,02,baoc|notActive|notInduced,notActive,notActive,notActive,noneDesignated,0,notActive|00|,notAc tive|00|,notActive|00|,notActive|00|30|,,

hi,

fields/column are not fixed,
given code will not work properly.
suggest else.

Thanks

Do the strings at least always stand between

Code:

subsD,<your string>,hlr

or start with subsD or end with hlr?
Or is the string itself fixed?

Need more precise info.

it starts with subsD,<String>,hlr.

its fixed pattern.