topic Re: Rename a list of files in Talend Studio

Rename a list of files

Mickael_Ro — Mon, 31 Mar 2025 09:46:24 GMT

I want to import files from an smtp server, put them locally and rename them. All this on a daily basis.
The files are in the form “filename+date.csv” except that I want to remove the date from the names of the various files.
Currently, I'm able to retrieve the files and put them locally, but I can't set the tFileCopy component to remove the date characters from the file name.

Thanks à lot

Re: Rename a list of files

mchapman — Mon, 31 Mar 2025 19:50:56 GMT

Before:

After:

Use this to remove the date from files (this example assumes .csv files with _ between the filename and the date, so modify the RegEx as needed):

((String)globalMap.get("tFileList_1_CURRENT_FILE")).replaceAll("_[0-9]{8}\\.csv$", "\\.csv")

Re: Rename a list of files

Mickael_Ro — Tue, 01 Apr 2025 07:12:16 GMT

I've used this and it works: