Importing Text file

[SAC]

I want to import a text file and I've tried the Get External Data wizard and
a TransferText macro. It's putting a blank line in the table between. I've
change the field size from 89 to 90 and I still get a blank record between
each filled in record in the table.

It looks like it has 89 characters and then a space, but I've tried
different delimiters (spce, tab) and it still places an extra record in
between.

Any ideas?

Also, I forget how to use readlin...maybe I'd read a line into a variable
and then parse it.

Is it something line Open File as 1...then readln into a varible?

Thanks for any help you might have.

 

[SAC]

I guess I could import the file into a table, run a delete query on the null
records, and then parse the remaining records.