Extract Info from Fixed Length file

[skb2005]

Hi Unix Guru's,

I have a fixed length format text file. I need to extract some information and save into another file.

Sample File format:

5IW8002240999 0001143324950059400999200703012007030104544804571200002248002240999

I need to extract the information enclosed in quotes as seperates columns, seperated by "|".

"5"IW8002240999 00011433249500"59400999"20070301"20070301"0454480457120000248002240999

The new File should look like
5|59400999|20070301

 

[PHV]

man awk (the substr function)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[skb2005]

Thanks for the quick response. I just landed to UNIX world, probably will take some to get used to.

Any example would make my life easy.

Thanks again.

 

[geirendre]

Maby this does it:

awk '{ print substr($0,1,1)"|"substr($0,42,8)"|"substr($0,50,8) }' fixedlenght.txt > result.txt

 

[skb2005]

Thanks for the quick help. That really worked.

 

[feherke]

Hi

Just as an idea, if happens to have [tt]gawk[/tt], you can use the [tt]FIELDWIDTHS[/tt] variable to chop a line with fixed length fields.

Feherke.

http://rootshell.be/~feherke/