convert a file using awk 1

[andrero]

Hello scripters,

I'd like to convert a file like
<$ MG_nr>
<!200>company-type
<!210>company-name
<!220>address
<!230>nr
<!240>zipcode
<!250>place
<!260>phone
<!270>fax
</$>
<$ MG_nr>
<!200>company-type
<!210>company-name
<!220>address
<!230>nr
<!240>zipcode
<!250>place
<!260>phone
</$>

...

into:
company-type!company-name!address!nr!zipcode!place!phone!fax
company-type!company-name!address!nr!zipcode!place!phone!fax
...

I guess I should use awk but I'm not very familiar with it, any help appreciated.

Regards, AndreRo

 

[PieterWinter]

Expand on:

awk -F\> '{ if ( $1 == &quot;<!200&quot; ) { ct=$2 }
else if ( $1 == &quot;<!210&quot; ) { cn=$2 }
else if ( $1 == &quot;</$&quot; ) { print ct &quot;!&quot; cn };
}' inputfile > outputfile

HTH