topic Re: Converting String format in excel to date format in db in Talend Studio

Converting String format in excel to date format in db

Anonymous — Thu, 03 Aug 2017 09:50:49 GMT

Hi,

I have an excel in which one column contains dates, however these dates are in the string format. I'd like to convert this column to a date format in db.

Could anyone please help me with this.

regards,

hs.

Re: Converting String format in excel to date format in db

Anonymous — Thu, 03 Aug 2017 10:20:54 GMT

Hi

You can use a tmap in between the excel input and the db output components. Where you can use Talend Date functions to convert it from String to Date.

Re: Converting String format in excel to date format in db

Anonymous — Thu, 03 Aug 2017 10:37:17 GMT

Can't you just change the schema in your tFileInputExcel (presume that's what you're using) so that the column has a correctly defined Date format?

Re: Converting String format in excel to date format in db

Anonymous — Thu, 03 Aug 2017 10:40:48 GMT

sir could you please help me with example.

for example: I have a column name modified on in excel and in that I have records in string format but data is filled with 8/3/12 12:00....so on

now I want the string data type to date data type while I am loading the excel to db.

regards,

sushmaaa

Re: Converting String format in excel to date format in db

Anonymous — Thu, 03 Aug 2017 13:27:05 GMT

Hi,

tFileExcelInput -> tmap -> tOracleOutput (example)
In the tmap component you can convert string to date in the expression editor of the particular object by using the below function.

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",your_Date_Column_in_String_Format)

This will convert your string to date

Thanks
Raghu

Re: Converting String format in excel to date format in db

Anonymous — Fri, 04 Aug 2017 05:50:12 GMT

thank you sir...

my input string is in 1/15/17 00:00 ..

so I have used this function in tMap :

TalendDate.parseDate("MM/dd/yy h:mm",your_Date_Column_in_String_Format)

and the string datatype is changed to date datatype in output.

I have one doubt , if I have a file in csv format,will it work?

Re: Converting String format in excel to date format in db

Anonymous — Thu, 10 Aug 2017 11:25:08 GMT

thank you..
its working