topic Re: Fetching the file with space in filename in Talend Studio

Fetching the file with space in filename

Rathesh — Thu, 23 Aug 2018 14:06:36 GMT

I want to load an excel file to database.Source File name will be like Test08232018.xlsx. Name of the file followed by current date. Sometimes there will be space between Filename and data. Job has to fetch fetch the file correctly even if it having space or not having the space.

Re: Fetching the file with space in filename

fdenis — Thu, 23 Aug 2018 14:52:48 GMT

where is your problem?
fileName can contain space.

Re: Fetching the file with space in filename

iamabhishek — Thu, 23 Aug 2018 16:04:33 GMT

Do you want a regular expression sort of functionality to search for your files which matches your criteria and then load to database?

Re: Fetching the file with space in filename

Rathesh — Thu, 23 Aug 2018 16:15:16 GMT

yes. but how to implement regular expression in the file path.

Re: Fetching the file with space in filename

Rathesh — Thu, 23 Aug 2018 16:16:41 GMT

Sometimes file name contains space between name and date and sometimes it won't

Re: Fetching the file with space in filename

fdenis — Thu, 23 Aug 2018 17:06:54 GMT

use tFileList, to list all files
then use Iterate on TFileInputExcel to load each file into db.
Use (String)globalMap.get("tFileList1_CURRENTFILEPATH") as fileName.
Regards

Re: Fetching the file with space in filename

Rathesh — Thu, 23 Aug 2018 17:17:40 GMT

I have two Excel files with different schema. Both of them has tobe loaded
into separate tables.
Eg:
First file name - TestReport08232018.xlsx
Second file name - Test08232018.xlsx

For loading first file, i am using tFileList.
Inside tFileInputExcel in path, I put filepath+"Test
report"+Talenddate.getDate("MMddyyyy")+".xlsx"

But how to load the second file. How to give path.sometimes space will come
between Test and date.

Re: Fetching the file with space in filename

iamabhishek — Thu, 23 Aug 2018 17:26:49 GMT

A regular expression match like this -

"Test(.*)"

would make sure that you are fetching all the files start with Test

Re: Fetching the file with space in filename

Rathesh — Thu, 23 Aug 2018 17:29:40 GMT

Regular expression for space is \s. I already tried (\s*). I am receiving
an error like invalid escape character.

Re: Fetching the file with space in filename

iamabhishek — Thu, 23 Aug 2018 17:49:36 GMT

You need to use - (\\s*)

Re: Fetching the file with space in filename

fdenis — Fri, 24 Aug 2018 07:47:09 GMT

tFileList List all your file.
for each file (iteration) file name is in (String)globalMap.get("tFileList1_CURRENTFILE") and check the name it may define tale name.
read data using tFileInputExcel you can get fileName full path in (String)globalMap.get("tFileList1_CURRENTFILE").
tFileList give you file name and path for each file you have to use iterate link then your tFileInputExcel will be run for each file.
Regards,

Re: Fetching the file with space in filename

Rathesh — Fri, 24 Aug 2018 13:59:08 GMT

I am receiving error like Zip File is closed, while trying to use regular expression (\\s*).