topic Re: Convert CSV-Date in new format in Talend Studio

Convert CSV-Date in new format

Anonymous — Mon, 08 Jan 2018 20:04:14 GMT

Hi,

i have a CSV File with a String information with following pattern dd.MM.yyyy i need to convert it to yyyy-MM-dd to import it into salesforce but i am not able to convert it. Could you please help me with my issue?

Thanks an best regards

Nuglo

Re: Convert CSV-Date in new format

Anonymous — Tue, 09 Jan 2018 00:19:27 GMT

You can use tFileInput or similar component depending on type of your file. Map the contents or input data elements to output (Salesforce component) using tMap. You can use formatDate which should return a date string which corresponds to the format specified.