You need to sign in to do that
Don't have an account?
jeffstuit
csv files/data loader
Here's a question that's come up for me in conjuction with the sforce data loader: does salesforce require that the field delimiter for a csv file be a comma and a double quote? (",")
I am attempting to import data into the comments (a long text field) in the tasks object. A lot of the data that I'm trying to import into this field has quotation marks in it as part of the data, which is causing it to fail. I could work around this if I could use a different field delimeter that I know doesn't exist in the data, in addition to the comma. For instance, I maybe I could use a ^, so ^,^ would be the delimiter?
Much thanks for any advice.
I am attempting to import data into the comments (a long text field) in the tasks object. A lot of the data that I'm trying to import into this field has quotation marks in it as part of the data, which is causing it to fail. I could work around this if I could use a different field delimeter that I know doesn't exist in the data, in addition to the comma. For instance, I maybe I could use a ^, so ^,^ would be the delimiter?
Much thanks for any advice.
1) This is the easiest solution and the one I would recommend. The parser will treat a " as a character if it is proceeded by a double quote. So if it sees [ " ] it will think its the end of the column, but if it sees [ "" ] then it will treat it as a double quote within the column. Just replace all of your " inside of your columns with "", and make sure the columns are still wrapped with a doube quote.
For instance, this will work
NAME, SUBJECT
"Lexi","This is some text with a single "" double quote in the middle"
2) Edit the CSVFile.java in the sourceforge project. It should be up and "official" by the end of day. (Note: re-pull the project if you did so previously, Brian) This actually may be a pain, that code is old, and may be up for re-writing anyhow.
Happy Loading.