Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem with CFcontent and XL
- Thread starter kann
- Start date
, when try to save as .csv file it is taking into seperate cell, where i need in the same cell.It sounds like you're not wrapping your alphanumeric fields in quotes. Numerics and dates do not need quotes because they won't have commas in them. If you had a file that contained name, shoe size and favorite color it would need to look like this:
"Doe, John", 11, "Blue"
"Doe, Jane", 6, "Red"
Etc..
CSV (Comma Separated Values) uses a text qualifier of "," so if a comma is not within quotes it assumes that it is a new field.
Hope this helps!
Andrew
amayer@sonic.net
"Doe, John", 11, "Blue"
"Doe, Jane", 6, "Red"
Etc..
CSV (Comma Separated Values) uses a text qualifier of "," so if a comma is not within quotes it assumes that it is a new field.
Hope this helps!
Andrew
amayer@sonic.net
- Status
Similar threads
- Locked
- Question