Is there a way to create a folder dynamically based on the first part of the filename in talend before copying the sftp file

Haresh — Sat, 16 Nov 2024 01:24:02 GMT

I am downloading a file from the remote sftp site and based on the filename for eg:A_B_C.csv before using tfilecopy in talend to transfer the file onto a local folder,how can i create a new folder based on the first part of the filename just before delimiter_(folder called A in this case) and then copy the file onto the specific folder called A?

Or even a java code to parse the filename and extract only A field from the filename (A_B_C.csv) and create a folder/directory and then copy the retrieved file into the same folder

Somebody please help

Re: Is there a way to create a folder dynamically based on the first part of the filename in talend before copying the sftp file

manodwhb — Thu, 24 Sep 2020 04:02:31 GMT

@Haresh Sivakumar , based on the SFTP file you need to take first occurrence of _ what value do you have right?

you need to use tFTPfileproperties and get the filename and then do use the substring and index of function to get the portion of the file name then iterate using tflowtoiterate and then you create a directory and download the file.

Thanks,

Manohar

topic Re: Is there a way to create a folder dynamically based on the first part of the filename in talend before copying the sftp file in Data Quality

Is there a way to create a folder dynamically based on the first part of the filename in talend before copying the sftp file

Re: Is there a way to create a folder dynamically based on the first part of the filename in talend before copying the sftp file