On Feb 7, 4:59 pm, "Shawn Milo" <[EMAIL PROTECTED]> wrote:
> On 7 Feb 2007 11:31:32 -0800, James <[EMAIL PROTECTED]> wrote:
>
>
>
> > Hello,
>
> > I'm a newbie to Python & wondering someone can help me with this...
>
> > I have this code:
> > --------------------------
> > #! /usr/bin/python
>
> > import sys
>
> > month ={'JAN':1,'FEB':2,'MAR':3,'APR':4,'MAY':5,'JUN':6,'JUL':7,'AUG':
> > 8,'SEP':9,'OCT':10,'NOV':11,'DEC':12}
> > infile=file('TVA-0316','r')
> > outfile=file('tmp.out','w')
>
> > for line in infile:
> > item = line.split(',')
> > dob = item[6].split('/')
> > dob = dob[2]+'-'+str(month[dob[1]])+'-'+dob[0]
> > lbdt = item[8].split('/')
> > lbdt = lbdt[2]+'-'+str(month[lbdt[1]])+'-'+lbdt[0]
> > lbrc = item[10].split('/')
> > lbrc = lbrc[2]+'-'+str(month[lbrc[1]])+'-'+lbrc[0]
> > lbrp = item[14].split('/')
> > lbrp = lbrp[2]+'-'+str(month[lbrp[1]])+'-'+lbrp[0]
> > item[6] = dob
> > item[8] = lbdt
> > item[10]=lbrc
> > item[14]=lbrp
> > list = ','.join(item)
> > outfile.writelines(list)
> > infile.close
> > outfile.close
> > -----------------------------
>
> > And the data file(TVA-0316) looks like this:
> > -----------------------------
> > 06-0588,03,701,03701,0000046613,JJB,05/MAR/1950,M,20/NOV/2006,08:50,21/
> > NOV/2006,V1,,,21/NOV/2006,AST,19,U/L,5,40,,
> > 06-0588,03,701,03701,0000046613,JJB,05/MAR/1950,M,20/NOV/2006,08:50,21/
> > NOV/2006,V1,,,21/NOV/2006,GGT,34,U/L,11,32,h,
> > 06-0588,03,701,03701,0000046613,JJB,05/MAR/1950,M,20/NOV/2006,08:50,21/
> > NOV/2006,V1,,,21/NOV/2006,ALT,31,U/L,5,29,h,
> > 06-0588,03,701,03701,0000046613,JJB,05/MAR/1950,M,20/NOV/2006,08:50,21/
> > NOV/2006,V1,,,21/NOV/2006,ALKP,61,U/L,40,135,,
> > -----------------------------
>
> > Basically I'm reading in each line and converting all date fields (05/
> > MAR/1950) to different format (1950-03-05) in order to load into MySQL
> > table.
>
> > I have two issues:
> > 1. the outfile doesn't complete with no error message. when I check
> > the last line in the python interpreter, it has read and processed the
> > last line, but the output file stopped before.
> > 2. Is this the best way to do this in Python?
> > 3. (Out of scope) is there a way to load this CSV file directly into
> > MySQL data field without converting the format?
>
> > Thank you.
>
> > James
>
> > --
> >http://mail.python.org/mailman/listinfo/python-list
>
> Your script worked for me. I'm not sure what the next step is in
> troubleshooting it. Is it possible that your whitespace isn't quite
> right? I had to reformat it, but I assume it was because of the way
> cut & paste worked from Gmail.
>
> I usually use Perl for data stuff like this, but I don't see why
> Python wouldn't be a great solution. However, I would re-write it
> using regexes, to seek and replace sections that are formatted like a
> date, rather than breaking it into a variable for each field, changing
> each date individually, then putting them back together.
>
> As for how MySQL likes having dates formatted in CSV input: I can't
> help there, but I'm sure someone else can.
>
> I'm pretty new to Python myself, but if you'd like help with a
> Perl/regex solution, I'm up for it. For that matter, whipping up a
> Python/regex solution would probably be good for me. Let me know.
>
> Shawn
Thank you very much for your kind offer.
I'm also coming from Perl myself - heard many good things about Python
so I'm trying it out - but it seems harder than I thought :(
James
--
http://mail.python.org/mailman/listinfo/python-list
