Raw Data

[sabetik]

I have a raw data that I need to import to Excel. It is a lot of work to use the Text to Cloumn(since I have to do it for each file. I would like to add space between each cloumn. Also my RAW data come with heading data that start with "H" and data line start with "D" I have differnet info in each line. here an example:

H9806206H4567432005011720050117000000000000000000000
DP76H5213V1301A 00062770066040 00000100000053070000000000053070 14

Thanks

 

[PHV]

And what is the expected result (and the rules) ?
In the awk man page take a look at substr

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244