topic Re: Add text to file name in Talend Studio

Add text to file name

Moe1 — Fri, 07 Sep 2018 09:48:43 GMT

Hi,

I need to change file name from

xxxxx_timestamp_randomnum.csv

xxxxx_timestamp_randomnum_ToAdd.csv

However when using this

((String)globalMap.get("tFileList_1_CURRENT_FILE"))+"_toadd.csv"

The output is:

xxxxx_timestamp_randomnum.csv_toAdd.csv

Re: Add text to file name

iamabhishek — Fri, 07 Sep 2018 10:02:43 GMT

Your final expression should be something like this -

((String)globalMap.get("tFileList_1_CURRENT_FILE")).substring(1,((String)globalMap.get("tFileList_1_CURRENT_FILE")).indexOf('.')) +"_toadd" + ((String)globalMap.get("tFileList_1_CURRENT_FILEEXTENSION"))

Re: Add text to file name

manodwhb — Fri, 07 Sep 2018 11:51:33 GMT

@Moe,try with below one.

replaceAll(((String)globalMap.get("tFileList_1_CURRENT_FILE")),".csv","")+"_toadd.csv"