Hi:
OK. We'll use 'sed' to translate the ,*, strings to a pipe as already done. At this point is appears that you want to make translations on field number 2, 6, and 9 if I understand correctly.
Hence, pipe the output of the 'sed' to an 'awk' script. Essentially, we will need to examine fields 2, 6, and 9 for anyone of the conditions you cited and substitute.
Using one of the lines in your file:
IIF ,*,22I,*,2,*, ,*,OS,*,036R,*, ,*, ,*,068G,*, ,*,
...THEN: sed -e 's/,\*,/|/g'
...produces:
IIF |22I|2| |OS|036R| | |068G| |
...which we pipe to an 'awk' script, the beginnings of which might look like:
awk -F\| 'BEGIN{OFS="|"}; $2~/..I/ {$2="xxx"};$6~/...R/ {$6="yyy"};{print $0}'
...which with the above data would yield:
IIF |xxx|2| |OS|yyy| | |068G| |
...I've used "xxx" and "yyy" for clarity of substitution. For brevity, I didn't write a complete 'awk' script, only enough to show conceptually my suggestion.
Regards!
...JRF...
