LinkBack URL
About LinkBacks
How can I use VBA to strip the excess semi-colons from the attached csv text file??
Is this even possible?
Thank you very much for your time and help
How can I use VBA to strip the excess semi-colons from the attached csv text file??
Is this even possible?
Thank you very much for your time and help
Hello erock24,
The file uses the semi-colon as a field separator. Use Text to Columns to convert the file.
- Select column "A" on the worksheet.
- On the main menu select Data >Text to Columns...
- Click the Delimited option button.
- Click the Next> button.
- Click the Semi-Colon check box for the delimiter.
- Click the Next> button.
- Click the Finish button.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
i know but I was hoping to remove the extra semi-Colons from the file before I did text to columns. Any ideas how to do that?
Hello erock24,
If you remove the semi-colons from the text then what will you use as a delimiter for the fields?
Anyway, you can use the Find/Replace dialog (Ctrl+F). On the Find tab enter a semi-colon and on the Replace tab enter "" (2 double quotes, no space) and click "Replace All".
thanks, the text to columns worked when I checked the box "Treat consecutive delimeters as one"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks