Convert CSV-Date in new format

Highlighted
Two Stars

Convert CSV-Date in new format

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

Four Stars

Re: Convert CSV-Date in new format

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.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.