importing data fram a text file

rsawning · Mar 27th, 2002, 04:47 PM

I have a rather large text file that is comma delimited. However, there are three line breaks per row of information that cause both the row headings and the records to spread over three rows and misalign. Any clue as to how to import he file and get rid of the "hard returns"?

Anne Troy · Mar 27th, 2002, 05:30 PM

Hmmm...sounds like it's time for SUPERWORD!

Generally, you can find/replace in text files with Word. If you can post a sample of, say three records, so I can find a pattern, I can post the finds/replaces that would work in Word, then you can import. Just put something like {BREAK} at the end of each record so I know where they end.

Damon Ostrander · Mar 27th, 2002, 07:05 PM

Hi rsawning,

The most efficient way to do this would be to read the data using VBA I/O rather than importing the file into Excel as a text file. To read a file using VBA I/O, check out the Open, Line Input #, EOF, and Close statements in the VBA helps. It really is not hard.

Mar 27th, 2002, 05:30 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Hmmm...sounds like it's time for SUPERWORD! Generally, you can find/replace in text files with Word. If you can post a sample of, say three records, so I can find a pattern, I can post the finds/replaces that would work in Word, then you can import. Just put something like {BREAK} at the end of each record so I know where they end. __________________ ~Anne Troy

Mar 27th, 2002, 07:05 PM	#3
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi rsawning, The most efficient way to do this would be to read the data using VBA I/O rather than importing the file into Excel as a text file. To read a file using VBA I/O, check out the Open, Line Input #, EOF, and Close statements in the VBA helps. It really is not hard. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 04:47 PM	#1
rsawning New Member Join Date: Mar 2002 Location: Frustrated Headbanger Posts: 1	I have a rather large text file that is comma delimited. However, there are three line breaks per row of information that cause both the row headings and the records to spread over three rows and misalign. Any clue as to how to import he file and get rid of the "hard returns"?