Excel 2003, cannot import quoted fields with separators inside

  • Thread starter Thread starter wxdeveloper
  • Start date Start date
W

wxdeveloper

Hello,

I have some data in UTF-8 encoded file with comma separated and quoted
values.
First I create an empty spreadsheet and then go to Data | Import
External Data | Import Data...
After selecting the file I choose "Delimited" data type (UTF-8
encoding is recognized automatically).

In the next setp I change Delimiters to "Comma" (only!). Text
qualifier is already set to double quotes.
I would expect in this case that value such as this:

"one, two, tree"

to be treated as one column. But excel breaks it into three columns

1. "one
2. two
3. three"

Am I doing something wrong ?

Thank you
J. G.
 
You are not doing anything wrong. It is up to you to decide how you want
the data imported.

Would you prefer "one, two, tree" in a single cell? If so, do not use
"comma" as the delimiter. So if you have data like i.e. "one, two, three"
"four, five, six" "seven, eight, nine" then use "space" as the delimiter.

Watch the preview in the Text Import Wizard closely to see what it will look
like before the data is fully imported.



Dennis
 
You are not doing anything wrong. It is up to you to decide how you want
the data imported.

Would you prefer "one, two, tree" in a single cell? If so, do not use
"comma" as the delimiter. So if you have data like i.e. "one, two, three"
"four, five, six" "seven, eight, nine" then use "space" as the delimiter.

Watch the preview in the Text Import Wizard closely to see what it will look
like before the data is fully imported.

Dennis
Click to expand...

Thank you. I did change the field separator from comma to semicolon
and now the data imports properly.

J. G.
 
Back
Top