Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.