topic Re: [resolved] get date from file name in Talend Studio

[resolved] get date from file name

Anonymous — Tue, 26 Apr 2016 23:09:51 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: [resolved] get date from file name

Anonymous — Tue, 26 Apr 2016 23:16:56 GMT

attaching file again

Re: [resolved] get date from file name

Anonymous — Wed, 27 Apr 2016 00:49:58 GMT

Since you do not know the filename, I am assuming that you are using the tFileList component to pass the filename to the component you are using to read it. If you aren't, then you probably should be. If you tFileList is called tFileList_1, the way to get the filename is to use this code....

((String)globalMap.get("tFileList_1_CURRENT_FILE"))

You can use that in a tMap and use a regex to get the date from the filename.

Re: [resolved] get date from file name

Anonymous — Wed, 27 Apr 2016 01:16:36 GMT

Hi, thank you for quick reply.
I've already managed to get the file name using tFileList. But what I could not figure out was how to get only date (201602) from "Data_f.cat.fy16.detail.201602.txt" and use it in tMap

Re: [resolved] get date from file name

Anonymous — Wed, 27 Apr 2016 01:48:57 GMT

You can use Java String functions "substring" and "indexOf" to do this. You know that the date comes just before ".txt" and you know it is 6 characters. That is all you need.

Re: [resolved] get date from file name

Anonymous — Wed, 27 Apr 2016 03:29:54 GMT

Hi ..
I have used the java string function as below, to get the date from the file name " Data_f.cat.fy16.detail.201602.txt" :
"ExtractDate="+(((String)globalMap.get("tFileList_1_CURRENT_FILE")).substring(23,((String)globalMap.get("tFileList_1_CURRENT_FILE")).indexOf(".txt")))
I've used 23 as that is the number of characters before 201602 in the file name, and then I got the output as desired which is ExtractDate=201602.
but, what if the number of characters before the date in the filename changes or varies?
PS: Sorry, I'm not from core development / programming background.

Re: [resolved] get date from file name

Anonymous — Wed, 27 Apr 2016 10:17:13 GMT

You use "indexOf" to work out where the ".txt" is in the String. Then you know that the start of your date is 6 characters before that position. You then have your beginning and end position.

Re: [resolved] get date from file name

Anonymous — Wed, 27 Apr 2016 20:22:56 GMT

I might sound too dumb but ..
what do I pass instead of 23? how do I tell to get last 6 digits (before .txt) instead of telling to ignore first 23 characters?

Re: [resolved] get date from file name

Anonymous — Wed, 27 Apr 2016 20:35:13 GMT

Try this.....
((String)globalMap.get("tFileList_1_CURRENT_FILE")).substring(((String)globalMap.get("tFileList_1_CURRENT_FILE")).indexOf(".txt")-6,((String)globalMap.get("tFileList_1_CURRENT_FILE")).indexOf(".txt"))

Re: [resolved] get date from file name

Anonymous — Wed, 27 Apr 2016 20:47:13 GMT

thank you very much .. it looks complete now .. Got It
where can I learn or what key words shall I use to search google .. to learn similar java (or string or any other) related functions to use in Talend .. not to learn complete Java.
thanks again

Re: [resolved] get date from file name

Anonymous — Wed, 27 Apr 2016 20:55:07 GMT

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/).

Re: [resolved] get date from file name

Anonymous — Wed, 27 Apr 2016 21:46:42 GMT

thank you .. i'll start learning Java for sure.