Results 1 to 3 of 3
Hello everyone. Since none of the other 3 threads found containing CSV match my question, I'm here writing to you with a simple question. I am using a web app ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
- 06-17-2014 #1
- Join Date
- Jan 2013
CSV - Are there any accepted special characters?
I am using a web app that lets you import CSV files to create data.
I have created a file that looks like this:
criteria1;criteria2;criteria3;criteria4 data1,data2,data3,data4 data1,data2,data3,data4 data1,data2,data3,data4
criteria1;criteria2;criteria3;criteria4 data1;da ta 2;data3;data4 data1;da ta 2;data3;data4 data1;da ta 2;data3;data4
I've already triedCode:
- 06-17-2014 #2
- Join Date
- Dec 2013
- Victoria, B.C. Canada
There is no default CSV processing specification. CSV stands for Comma Separated Values and generally, a reasonable expectation would be, the values will be treated as columns of data separated by commas with rows delineated by new lines. It may be the case that the web app has the ability to do something different and if you indicate what the application is someone may be able to help you with that.
Otherwise if the app accepts html tags you may be able to format the input this way. i.e.
- 06-18-2014 #3
As Greg pointed out, there's no one consistent standard for dealing anything except the most simple data. It really depends on what's reading the data. If I were writing the script, I might adopt a convention of requiring embedded newlines to be expressed as "\n" without the quotes:
criteria1;criteria2;criteria3;criteria4 data1;da\nta\n2;data3;data4 data1;da\nta\n2;data3;data4 data1;da\nta\n2;data3;data4
Oh what a tangled web!
Last edited by mrbruno; 06-19-2014 at 12:36 PM. Reason: typo: "double word": "as as"