Text File Input

[Jimgarry]

I want to bring in a text file. the data is 80 characters long but the text file dosent contain line feeds so the data look like one very long string. How can I bring this data into a file?

Thanks in advance
Jim Garry

 

[foxdev]

You should be able to use some variation of the [tt]APPEND FROM ... SDF[/tt] command to do it.

Robert Bradley

http://www.foxdev.com/

 

[Jimgarry]

Ive tried the append and import from with the SDF it only brings in one record.

Is there some way of breaking up a text file?

 

[BlindPete]

How big is it?
>32000 chars?

You could import into a memo then use:

SET MEMOWIDTH TO nColumns
MEMLINES(MemoFieldName)
MLINE(MemoFieldName, nLineNumber [, nNumberOfCharacters])
etc...

good luck


-Pete

 

[foxdev]

With APPEND FROM...SDF, did you play with the DELIMITED WITH gizmo?

Failing that, would it be practical to first pre-process the file by inserting a CR every 80 bytes?

Robert Bradley

http://www.foxdev.com/