This topic contains 3 replies, has 0 voices, and was last updated by Anonymous 9 years, 3 months ago.
- January 30, 2012 at 5:10 pm #943
I’m trying to create lists with commas in them with “city, states”.
Using the quick input a comma is the delimiter for value.
Importing a .csv file imports the names with quotes around them, which I have to manually remove.
How can I do quick input or CSV such that imports will have the commas excluded as delimiters and quotes won’t appear around each item?
Also, is it possible to export a list?
VincentJanuary 31, 2012 at 12:14 am #5994
Dennis @ PerfectFormsBlockedFebruary 9, 2012 at 6:33 pm #6004
City and state are in the same column:
ex. Column1 on xls
New York, NY
Los Angeles, CA
When I create a .csv file and import this, perfectforms places quotes around the imported data, to which I have to manually remove.February 9, 2012 at 10:03 pm #6006
I justed tested this myself, and it’s Excel that puts in the double quotes. I entered Vincent’s list of city/states into one column in Excel 2003. I then saved the file as a CSV and immediately opened that CSV file in Notepad. The double quotes were present when I opened it in Notepad.
I would suggest opening your CSV file in Notepad after saving it in Excel and doing a Find/Replace to remove the double quotes.
You must be logged in to reply to this topic.