Import from TXT file with "No record delimiter"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CanaKiwi - 12 Jul 2007 23:16 GMT

I'm trying to import data from a text file into excel.

Each record is 331 characters and there are no record delimiters. The file
ends with a carriage return and line feed (ASCII13 and ASCII 10)

I'm having no luck importing it and only get one record when I manually
select the field lengths.

Can anyone help?

TIA
KIWI

Reply to this Message

Pete_UK - 12 Jul 2007 23:46 GMT

How many records are in the file? Perhaps you can load it into Notepad
first and adjust the font to Courier 6pt and adjust the margins so
that you can just get 332 characters on a line, and then manually
press Enter after 331 characters. If you have a lot of records this
might not be feasible.

Once you have worked through the file then save it and try to import
it again through the Text Import Wizard.

Hope this helps.

Pete

> I'm trying to import data from a text file into excel.
>
[quoted text clipped - 8 lines]
> TIA
> KIWI

Reply to this Message

CanaKiwi - 09 Aug 2007 23:02 GMT

if anyone is interested I did this on a Ubuntu box using sed

> How many records are in the file? Perhaps you can load it into Notepad
> first and adjust the font to Courier 6pt and adjust the margins so
[quoted text clipped - 22 lines]
>> TIA
>> KIWI

Reply to this Message