June 15, 2020 at 1:57 pm
The reason the columns do not line up is because you have commas in the data. To avoid this issue you need to set the text qualifier to a double-quote.
For example - in your actual results (open the file in notepad):
An County,Bed,5
An County,Bed or Breakfast,6
Ann,Cottage,Cabin or Min,45
What you should have is:
"An County","Bed","5"
"An County","Bed or Breakfast","6"
"Ann,Cottage","Cabin or Min","45"
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
June 15, 2020 at 3:20 pm
Thanks for all the help, I'll try this out.
June 15, 2020 at 6:31 pm
you need to add " (double quote) as the text delimiter on the definition above - once you do that you will be able to open the file correctly in Excel.
Note that as I said before you do need to use a program that is capable of reading and parsing CSV files correctly.
June 15, 2020 at 7:05 pm
thank you I will try that
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply