I'm using talend open studio data integration and new to this tool.
I have a csv file that has timestamp column and i'm trying to convert this in the schema of the input delimted_file. and I get the below error.
Couldn't parse value for column 'Tx_Timestamp' in 'row1', value is '07-JUL-18 05.17.36.000 PM -05:00'. Details: java.lang.RuntimeException: Unparseable date: "07-JUL-18 05.17.36.000 PM -05:00"
I tried this various options like "dd-MMM-yy HH.ms.ss.SSS a Z" but nothing helped.
Please let me know.
Yes this is exactly the output I need . so I need to us this following below to convert it?
TalendDate.ParseDateinUTC ( )
and I won't be able to use this in the FileInput_Delimted . under edit schema? Correct?
I can use it in tmap in expression editor and use that as a separate column/variable?
When I have to convert a TimeStamp field to a DateTime field, I like to create a routine in Talend for these purpose, and I'm going to show you how with a simple example where I've got a .csv input with a TimeStamp in milliseconds connected to tMap and the tMap output to a .csv output where I'm going to have two fields, the old timestamp and his correspondent DateTime.
-> This is the .CSV file input
Now I'm going to show you the talend routine to convert timestamp in milliseconds to datetime ("dd:mm:YY HH.mm.ss.SSS")
In the next step, you only have to aplpy the created routine in the tMap output option, expression builder!
Now just Run the job and woalah! \(^.^)/
-> .CSV file output
Pls, give me some Kudos if my response help you
Thanks for your time and attention <3
I have a date format in the below form in the csv file. how can I convert this?
or what is the expression used I can store in the proper format?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
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