[NTLUG:Discuss] perl question

MadHat madhat at unspecific.com
Wed Jun 4 11:46:04 CDT 2003


On Wed, 2003-06-04 at 11:38, Bobby Wrenn wrote:
>  
> The file will come from a M$ Excel spreadsheet. I can jerk the text out
> and make sure there are no commas. Then I think I can look for a space 2
> alpha characters and a new line and stick a comma back in after the
> city. Then the only problem is to get rid of everything but the line
> with city state and zip.

Why not export it as a CSV or XML, it would be easier to deal with.

-- 
MadHat at Unspecific.com
`But I don't want to go among mad people,' Alice remarked.
`Oh, you can't help that,' said the Cat: `we're all mad here...'
   -- Lewis Carroll - _Alice's_Adventures_in_Wonderland_




More information about the Discuss mailing list