Apex Code Development You need to sign in to do that
Don't have an account?
Suzanne Ellmer Can DataLoader export using other available delimiters?
I've been asked to export data using dataloader from which I was able to export CSV files.
However I have been informed that these have delimiter being “,” this is causing us some problems with some of the data rows – and making it challenging for us to profile.
It appears that there are genuine commas in some of the address fields (and other such fields) and this then wrongly splits them into subsequent columns – impacting all of the remaining downstream columns.
Does the DataLoader provide the ability to export using other available delimiters?
Would you be so kind to request another export with the delimiter being pipe (“|” ) if at all possible please?
However I have been informed that these have delimiter being “,” this is causing us some problems with some of the data rows – and making it challenging for us to profile.
It appears that there are genuine commas in some of the address fields (and other such fields) and this then wrongly splits them into subsequent columns – impacting all of the remaining downstream columns.
Does the DataLoader provide the ability to export using other available delimiters?
Would you be so kind to request another export with the delimiter being pipe (“|” ) if at all possible please?
Hi Suzanne Ellmer,
Presently we can not give a "|" as a delimiter in a data loader.By default "," is used as a delimiter.
Hear is a link to ideas where they ask for the same:-
Idea Link:. https://success.salesforce.com/ideaview?id=08730000000IFzyAAG#
Further to give you the solution to your problem you may use jitterbit salesforce data loader :http://www.jitterbit.com/solutions/salesforce-integration/salesforce-data-loader/