I have an issue with loading a correct mapped csv file.
Input CSV (with header) is like:
Output (in Salesforce Text fields) should be like:
But it is actually like:
First data set:
Second data set:
Rough configuration is like tFileInputDelimited-->tMap-->tSalesforceBulkExec
tFileInputDelimited settings are:
CSV Row Seperator: CRLF("\r\n")
Field Seperator: ";"
Escape Char: """
Text enclosure: """
Skip empty rows: true
Right now I have no clue what is possibly wrong.
For any help I would be very grateful.
Solved! Go to Solution.
I recognized an possible issue.
Not all dataset have that problem. So the CRLF might not be the problem.
The datasets, which aren't mapped properly has "" within the field3
That might cause the problem. Nevertheless I would think the marked field seperator ";" indicates the individual fields and is not influenced by the text enclosure.
How can I mitigate that problem?
thanks for reply!
I configured the field in the tMap out expression for the mentioned field like:
Now I get a compile Error ( The method replace(chat,char) in the type String is not applicable for the arguments (String) )
Did I understand you right?
replace is for char, not for string.
As soon as you have more than 1 char you need to use replaceAll such as
You need to try, I can't actually on my side
Ok, thanks for the hint!
I did it like you suggested:
Unfortunatly I get now a NullPointerExeption in the tMap component.
Any ideas left?
Hello, I have still no success.
I tried several combination of configurations in the tFileDelimited compenent (Escape char, Text enclosure, etc.) and with the replace funtion.
Is there any other solution? E.g. is it possible to use more than one char for the field seperator (In this case: "";"" instead of ";").
This would maybe solve it.
Thanks for your suggestions.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables