File name with a timestamp

[Anonymous]

Hi,
I have one question.
I want to give my file's name with a time stamp
It will be like "filename_yyyyMMdd_HHmm.dat"
But I have to find this file again in the job so, I want to store the "yyyyMMdd_HHmm" value in a context or variable.
and assign that context or variable to the file name.
Can you direct me how it can be done???
I've tried making a context of type string whose value is TalendDate.formatDate("yyyyMMdd_HHmm",TalendDate.getCurrentDate())
But when i run it i got a file not found exception (I'm to create a file not find for the first time).
and I think the context returns as a string of "TalendDate.formatDate("yyyyMMdd_HHmm",TalendDate.getCurrentDate())" not the actural date time value.
Thank You.

[Anonymous]

@Puspanjali12 

   Could you please let us know the exact format you are looking?

   Then we can suggest the corresponding format to you.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

@nthampi 

I want to append the current date in a filename and the date should be in CST timezone.
for ex: data02212019051444

Regards,

Puspanjali

[Anonymous]

@Puspanjali12 

Please refer the below diagram.

I have used the java libraray joda-time and the screen shots for tlibraryload are as below.

 import org.joda.time.DateTime;
 import org.joda.time.DateTimeZone;
 import org.joda.time.format.DateTimeFormatter;
 import org.joda.time.format.DateTimeFormat;

tMap screenshot is as below.

row1.input+DateTime.now(DateTimeZone.forID( "America/Chicago" ) ).toString(DateTimeFormat.forPattern("MMddyyyyHHmmss"))

And you got the answer 🙂

Please spare a second to mark the topic as resolved. Kudos are also welcome 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

@nthampi 

Thanks. It's working!!

[Anonymous]

The best for me

[Anonymous]

excelent...!

filename with datestamp.png

[SJeshwani1618330394]

Hey hi @pariyarath Kiran​ ,

Your solution is working perfectly when we give it in a file path, but I want to use context variable and while I am giving this path in a context variable, it's not working.

do you have any idea about this?

Thank you

Regards,

Sheetal

[1636848613]

"D:/filedirectory/fileout_"+TalendDate.formatDate("yyyyMMdd_HHmm",TalendDate.getCurrentDate())+".csv"

Seems to work when writing a file, but not on tFileCopy??

[1636848613]

Diregard... needed spaces around + 😂