| Message Text |
Dear Paul,
I'm sorry to bother you again with another import problem, but I'm hoping you can figure out a way around this one as well.
I am trying to import a csv file, unfortunately I realized tonight that some of the fields already include a comma. For example, I have a field with the following information - Clapton, Eric and another field with London, England. When I export from excel it lists them as "Clapton, Eric","London, England" to make up for the additional commas. When I tried importing it imported
first field - "Clapton
second field - Eric"
third field - "London
etc.
I can try to change it to a tab-delimited file, but there is no way to tell wsn that the separator is now a tab and not a comma. I also do not need to have the quotes imported in most cases, but excel puts double quotes around any information that actually has quotes in the data itself. So for example, I do not need the quotes imported for "Clapton, Eric", but I would want them imported for "Crossroads" - which would export as ""Crossroads"".
Thanks in advance for your help.
Marilyn |
