Feb 16, 2009, 4:56 AM
Post #1 of 1
Below is my input file,
AAA BBB CCC3:DDD*4:EEE*8:FFF*250:GGGG*33:H
AAA BBB CCC3:DDD*4:EE*8:FFF*250:GG*33:H
AAA BBB CCC3:DD*4:EEE*8:FFF*250:GGGGGG*33:HH
I need to convert to,
(null) (null) (null) 3 4 8 250 33
AAA BBB CCCC DDD EEE FFF GGGG H
AAA BBB CCCC DDD EE FFF GG H
AAA BBB CCCC DD EEE FFF GGGGGG H
*4:, *8:, *250: in general "*/d+:" is the column delimiter, which has to be converted into column headings.
This is not a fixed length file.
In the input,
AAA BBB CCC3:DD
The first two columns are delimited by a tab and the third one by "3:", which can be ignored as of now.
and this perl program runs on windows
thanx a ton for your comments.
(This post was edited by razorBlades on Feb 16, 2009, 5:01 AM)