I am trying to copy data from a text file into a spreadsheet. However the data in the text file contains null characters (resultant of an FTP from a mainframe dataset), causing the readline to drop the entire text once the null characters start. Suggestions for any of the following would be appreciated-
1. Replace the nulls with spaces in VBA
2. Replace the nulls with spaces while FTP is done
3. Coax FileSystemObject readline to recognize data beyond the nulls.
or anything which you feel may help the cause.
Thanks,
Sam
Hi Sam and welcome to the forum.
Open the text files in word and click on the Paragraph icon. This will show all characters. Copy one of these funny characters to the Find feature in Word and Replace them all with a Space.
Save you file to a different name than the original and see if it imports any better.
If you get it into Excel use the Code Function to find and remove the funny characters.
One test is worth a thousand opinions.
Click the * below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks