Talend read filename and use that information

[pcbillions53]

Hi,

Is it possible to set Talend to read the filename, in order to use/process that information?

Say I have a spreadsheet name SALES_APRIL_WEEK_01.XLS. How could I use that "WEEK_01" information in a Job, or something like that?

Best wishes,

[Yomane]

Use a tjava to get current_sheet_name from tfile input and extract the Week 1 using regex.

[Anonymous]

Hello,

Please have a look at this related topic: https://community.talend.com/s/question/0D53p00007vCjxxCAC/read-folder-and-use-the-filename-for-furt...

Feel free to let us know if it helps.

Best regards

Sabrina