topic Get name tFileInputExcel in Talend Studio

Get name tFileInputExcel

jmialoundama — Fri, 15 Nov 2024 23:18:37 GMT

Hi,

I developed this job and want to retrieve the name of the excel file as the output name of my CSV file.

I tried to go through a context variable in which I put:

FILE_INPUT_EXCEL = /doc/input/test.xlsx

So I want my CSV file to be called test.csv

How could I do this?

I know I can go through the tFileList component but I don't have a list of files to process.

thanks in advance

Anonymous — Fri, 14 Jan 2022 08:10:53 GMT

If you have a context variable which stores the file path like "/doc/input/test.xlsx", then you can extract the file name from this variable.

context.filepath.substring(context.filepath.lastIndexOf("/")+1)

Regards

Shong

gjeremy1617088143 — Fri, 14 Jan 2022 08:11:14 GMT

Hi maybe you can use the global Var created by the tFileExist : (String)globalMap.get("tFileExist_1_FILENAME").

Send me love and kudos

Anonymous — Fri, 14 Jan 2022 08:31:40 GMT

Hello,

You can use tFileList componen even if you have only one excel file.

((String)globalMap.get("tFileList_1_CURRENT_FILE")) is a variable created by the tFileList component for each file it found.

Best regards

Sabrina