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.
Learning Java is a must for Talend when you want to see what Talend can really do. But even the smallest things make use of simple Java concepts. Look for some Java tutorials online and download a copy of Eclipse (or similar). Once you have got a few examples under your belt, you will start to understand a bit more to ask (Google) the right questions. A lot of people (at University and other places) use a book called "Objects First with BlueJ" (
http://www.bluej.org/objects-first/).
