topic Re: How tio remove the extension from file and copy it in Talend Studio

How tio remove the extension from file and copy it

Anonymous — Sat, 20 Oct 2012 09:02:22 GMT

Hi ,
I am new to talend,
I need to read the multiple file in a folder , File name is with extension for instance (category.csv)
after read and load the data into table , i need copy the source file without the extension and put it into target directory. so what i did was
On component ok
tfilelist------tfileinputdelimited------tmap----toracleoutput-------------------------TFilecopy
the below expression i written in tfilecopy in destination filename
StringHandling.LEFT(((String)globalMap.get("tFileList_1_CURRENT_FILE")),6)
The above expression working in the case if the file contains 6 characters ,
if its more than that its not working, so i need to do this dynamically any help.......

Re: How tio remove the extension from file and copy it

Anonymous — Sat, 20 Oct 2012 10:46:22 GMT

Hi
Try this expression

((String)globalMap.get("tFileList_1_CURRENT_FILE")).substring(0, file.indexOf("."))

Re: How tio remove the extension from file and copy it

Anonymous — Thu, 06 Sep 2018 10:33:18 GMT

Below Expression worked for me:

StringHandling.LEFT(((String)globalMap.get("tFileList_1_CURRENT_FILE")),StringHandling.INDEX(((String)globalMap.get("tFileList_1_CURRENT_FILE")),"."))

Best Regards,

Ram