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"?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
importing data fram a text file
- Thread starter rsawning
- Start date
Anne Troy
MrExcel MVP
- Joined
- Feb 18, 2002
- Messages
- 2,632
- Office Version
- 365
- Platform
- Windows
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.
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.
Upvote
0
Damon Ostrander
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 4,239
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.
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.
Upvote
0
