Re: convert non-delimited to delimited

2009-08-08 Thread MRAB
John wrote: I am not really a CS person, but I have a task to import a non-delimited text to an access database. After some research, I *think* the best way to do this is by first converting the non-delimited text to delimited text, and then import it to the database. Is this the best way to

Re: convert non-delimited to delimited

2007-08-27 Thread Paul McGuire
On Aug 27, 12:59 pm, RyanL <[EMAIL PROTECTED]> wrote: > 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: > 01397256359210100534+42050-102800FM-15+1198KAIA > > Should be: > 0139,725635,9,2000,01,01,00,53

Re: convert non-delimited to delimited

2007-08-27 Thread Neil Cerutti
On 2007-08-27, RyanL <[EMAIL PROTECTED]> wrote: > 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: > 01397256359210100534+42050-102800FM-15+1198KAIA > > Should be: > 0139,725635,9,2000,01,01,00,53,4,+42

Re: convert non-delimited to delimited

2007-08-27 Thread Matimus
On Aug 27, 10:59 am, RyanL <[EMAIL PROTECTED]> wrote: > 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: > 01397256359210100534+42050-102800FM-15+1198KAIA > > Should be: > 0139,725635,9,2000,01,01,00,53

Re: convert non-delimited to delimited

2007-08-27 Thread Michael Bentley
On Aug 27, 2007, at 10:59 AM, RyanL wrote: > 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: > 01397256359210100534+42050-102800FM-15+1198KAIA > > Should be: > 0139,725635,9,2000,01,01,00,53,4,+42050

Re: convert non-delimited to delimited

2007-08-27 Thread [EMAIL PROTECTED]
On Aug 27, 1:35 pm, Mark Elston <[EMAIL PROTECTED]> 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: > > 01397256359210100534+42050-102800

Re: convert non-delimited to delimited

2007-08-27 Thread Mark Elston
* 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: > 01397256359210100534+42050-102800FM-15+1198KAIA > > Should be: > 0139,725635,9,2000,01,01,00,53,4,+42050,-10

convert non-delimited to delimited

2007-08-27 Thread RyanL
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: 01397256359210100534+42050-102800FM-15+1198KAIA Should be: 0139,725635,9,2000,01,01,00,53,4,+42050,-102800,FM-15,+1198,KAIA What is the best way to go about t