convert non-delimited to delimited

[mensanator at aol.com]

On Aug 27, 1:35 pm, Mark Elston <m.els... at advantest-ard.com> wrote:
> * RyanL wrote (on 8/27/2007 10:59 AM):
>
>
>
>
>
> > I'm a newbie!  I have a non-delimited data file that I'd like to
> > convert to delimited.
>
> > Example...
> > Line in non-delimited file:
> > 0139725635999992000010100534+42050-102800FM-15+1198KAIA
>
> > Should be:
> > 0139,725635,99999,2000,01,01,00,53,4,+42050,-102800,FM-15,+1198,KAIA
>
> > What is the best way to go about this?  I've looked all over for
> > examples, help, suggestions, but have not found much.  CSV module
> > doesn't seem to do exactly what I want.  Maybe I'm just missing
> > something or not using the correct terminology in my searches.  Any
> > assistance is greatly appreaciated!  Using Python 2.4
>
> Since you have to know, a priori, how to break the input string I
> assume that these fields are of fixed length.  You can use the following
> to do what you want:
>
>  >>> a="0139725635999992000010100534+42050-102800FM-15+1198KAIA"
>  >>> print "%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s" %
>      (a[0:4],a[4:10],a[10:15],a[15:19],a[19:21],a[21:23],a[23:25],
>       a[25:27],a[27],a[28:34],a[34:41],a[41:46],a[46:51],a[51:])
>
> which results in the following output:
>
> 0139,725635,99999,2000,01,01,00,53,4,+42050,-102800,FM-15,+1198,KAIA
>
> Mark

Or try this:

import struct
test = '0139725635999992000010100534+42050-102800FM-15+1198KAIA'
template = '4s6s5s4s2s2s2s2s1s6s7s5s5s4s'
the_line = struct.unpack(template,test)
print the_line
print ','.join(the_line)

##  ('0139', '725635', '99999', '2000', '01', '01', '00', '53', '4',
'+42050', '-102800', 'FM-15', '+1198', 'KAIA')
##
##
0139,725635,99999,2000,01,01,00,53,4,+42050,-102800,FM-15,+1198,KAIA