elbastador
New Member
- Joined
- Oct 7, 2005
- Messages
- 36
I'm using a macro to import a series of fixed-width text files. The problem I'm having is that for some lines of data the name field will drop all the spaces in the name and screw up those lines of data. For example something like this:
John Moe Doe 1003 10000
Will get imported as this:
JohnMoeDoe 1003 10000
This only happens to a few lines and I can't figure out why. When this does happen, it messes up the spacing with the following fields and that line does not get imported correctly. So instead of the cell saying "John Moe Doe" it will say "JohnMoeDoe10" and the following cell would be "03 10000". I opened the file in a text editor and this does not happen. Does anybody have any idea what is causing this and how to prevent it?
Thank you!
John Moe Doe 1003 10000
Will get imported as this:
JohnMoeDoe 1003 10000
This only happens to a few lines and I can't figure out why. When this does happen, it messes up the spacing with the following fields and that line does not get imported correctly. So instead of the cell saying "John Moe Doe" it will say "JohnMoeDoe10" and the following cell would be "03 10000". I opened the file in a text editor and this does not happen. Does anybody have any idea what is causing this and how to prevent it?
Thank you!