get date from file name

Anonymous — Tue, 26 Apr 2016 23:09:32 GMT

Hi,
I am unable to get Date from a file name to use in tmap expression editor.
Attached is my Job design and tMap editor view.
1) The tFileRowCount input file name is like "Data_f.cat.fy16.detail.201602.txt". Now I need to read the date part which is "201602" in this case (YYYYMM) and pass it to the "ExtractDate" expression in the tMap expression editor on the output file. For now I've hardcoded "ExtractDate=201602" as you can see in the attached image, but as per the requirement it should read the date from the actual date file name, which is given as input for tFileRowCount in the current job.
2) Is there any way to achieve with and/or without tJava related components
Let me know if I am not very clear about the requirement.

thank you for your time.

Re: get date from file name

Anonymous — Wed, 27 Apr 2016 04:57:34 GMT

Hi,
Can you upload again the screenshots you wanted to show, please? For some reason it didn't make it to your post.
Best regards
Sabrina

topic Re: get date from file name in Talend Studio

get date from file name

Re: get date from file name