topic Re: How to read and rename a file ? in Talend Studio

How to read and rename a file ?

Anonymous — Sat, 16 Nov 2024 02:32:46 GMT

Hi everyone,

I want to read the file name and rename it as follows:

xyz_20200101_1234 -> xyz_CW01_1234

xyz_20200108_1234 -> xyz_CW02_1234

What do you suggest to enable this task?

Kind regards,

Newbee

Re: How to read and rename a file ?

manodwhb — Thu, 30 Apr 2020 07:56:43 GMT

@TalendNewbee11, check the below case is similar.

https://community.talend.com/t5/Design-and-Development/Copy-multiple-files-and-rename-them-and-remove-the-source-file/td-p/119086

Re: How to read and rename a file ?

Anonymous — Thu, 30 Apr 2020 08:09:17 GMT

unfortunately it is not the same.

I need to read a part of the file name. In my example it is the file date. After that, I need to convert the date into the calender week format/week number format.

Best regards,

Newbee

Re: How to read and rename a file ?

manodwhb — Thu, 30 Apr 2020 11:44:16 GMT

@TalendNewbee11 , you use the tfileist and then use some java to convert to whatever you want to need,for that you need to know java.

Re: How to read and rename a file ?

Anonymous — Thu, 30 Apr 2020 11:52:33 GMT

@manodwhb yes, I know. It works to rename a file and move it to another folder.

However, my case is the following:

I have a file name that I want to analyze. There are 3 pieces of information within this file name:

XXX_20200430_1234

XXX = name , 20200430 = Date in which the file was written , 1234 = serial number

In this case I would like to explicitly convert the date within the file name to another date format

The other information should be copied.

The result should be:

xxx_CW17_1234

Re: How to read and rename a file ?

manodwhb — Fri, 01 May 2020 08:53:17 GMT

In Java first you need to split those values into three different variables and then take current week date and concatenate with first variable + current week variable + serial number variable.