topic Re: Scripting in Operating System - HP-UX

Scripting

Arman Mahboobi — Thu, 26 Sep 2002 23:50:42 GMT

Hi,

I would like to reformat a file by removing all the ,*, fields from the attached txt file. Your scripting knowledge would be muchly appreciated.

Re: Scripting

Arman Mahboobi — Thu, 26 Sep 2002 23:57:25 GMT

Oh, and also I would like to convert fields
221 to Q0
**I to O6 (where * wild)
***R to O4 (where * wild)
***G to P1 (where * wild)

Many thanks

Re: Scripting

James R. Ferguson — Fri, 27 Sep 2002 00:02:33 GMT

Hi:

This will remove all occurances of the string comma_asterisk_comma:

# sed -e 's/,\*,//g' filename

Is that what you want?

Regards!

...JRF...

Re: Scripting

Arman Mahboobi — Fri, 27 Sep 2002 00:08:00 GMT

Sorry, I would like to replace the ,*, fields with a pipe instead of removing it.

Re: Scripting

James R. Ferguson — Fri, 27 Sep 2002 00:08:26 GMT

Hi Again:

# sed -e 's/,\*,/|/g' filename

...JRF...

Re: Scripting

Arman Mahboobi — Fri, 27 Sep 2002 00:39:19 GMT

Hi James,
Thankyou very much for your help.
Thats getting near to what I need, all I need now is changing the following fields
22I to Q0 (field 2)
**I to O6 (field 2 where * is wild)
***R to O4 (field 6 where * is wild)
***G to P1 (filed 9 where * is wild)

Re: Scripting

James R. Ferguson — Fri, 27 Sep 2002 01:45:00 GMT

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...

Re: Scripting

Arman Mahboobi — Fri, 27 Sep 2002 03:54:29 GMT

Man,

How can I thankyou, If you were in Australia I would buy you a beer.