topic Re: HOW TO GET FILEDATE IN TMAP in Talend Studio

HOW TO GET FILEDATE IN TMAP

k526 — Mon, 29 May 2017 13:45:26 GMT

hi ,

how to get filedate. myfilename is pk_20110504124523.csv

i need the date format like this 2011-05-04 12:45:23

i tried like this ((String)globalMap.get("tFileList_2_CURRENT_FILE")).sub string(3,17) .am getting like this 20110504124523.

can any one help me.

Re: HOW TO GET FILEDATE IN TMAP

vapukov — Mon, 29 May 2017 14:39:40 GMT

try this

TalendDate.parseDate("yyyyMMddHHmmss",((String)globalMap.get("tFileList_2_CURRENT_FILE")).sub string(3,17))

with column type Date and pattern "yyyy-MM-dd HH:mm:ss" it must return proper result

Re: HOW TO GET FILEDATE IN TMAP

k526 — Mon, 29 May 2017 14:46:17 GMT

Thank you so much this is working fine

Re: HOW TO GET FILEDATE IN TMAP

vapukov — Mon, 29 May 2017 14:47:42 GMT

@k526 wrote:
cannot convert from date to string

of course, because - it return Date (see my message)

if need string - add one more function formatDate() - it return string

TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",TalendDate.parseDate("yyyyMMddHHmmss",((String)globalMap.get("tFileList_2_CURRENT_FILE")).sub string(3,17)) )

Re: HOW TO GET FILEDATE IN TMAP

vapukov — Mon, 29 May 2017 15:02:32 GMT

Welcome! 🙂