topic Re: date extracting issue while reading from tFileInputexcel in Talend Studio

date extracting issue while reading from tFileInputexcel

Anonymous — Sat, 16 Nov 2024 04:44:11 GMT

As per requirement i need to read and keep the date in string format only. (MM-dd-yyyy)

input "7/25/2018" i am getting in this format but when data pass through tMap I am getting "7/25/18" in this format.

let me know how to get "07/25/2018" in this format.

Re: date extracting issue while reading from tFileInputexcel

manodwhb — Mon, 09 Sep 2019 13:37:34 GMT

@sandeephakki ,check the below way in tmap.

Re: date extracting issue while reading from tFileInputexcel

manodwhb — Mon, 09 Sep 2019 13:39:23 GMT

@sandeephakki ,check the below link also.

https://community.talend.com/t5/Design-and-Development/Capture-Invalid-Date-type-Values-in-tMap-reject-flow/m-p/201403#M109977

Re: date extracting issue while reading from tFileInputexcel

Anonymous — Tue, 10 Sep 2019 07:00:14 GMT

Hi manodwhb,

It's not working. My input in .xlsx sheet is "7/25/2018" when talend reads it i am getting "7/25/18", if i try to convert in all the forms i am getting "7/25/0018".

Ultimately i need "7/25/2018" or "7-25-2018" in this format. year shouldn't crop or append 00.

Re: date extracting issue while reading from tFileInputexcel

manodwhb — Tue, 10 Sep 2019 07:18:50 GMT

@sandeephakki ,it could be source data issue,please check with source team.