Fetching the file with space in filename

[Rathesh]

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.

[fdenis]

where is your problem?
fileName can contain space.

[iamabhishek]

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

[Rathesh]

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

[Rathesh]

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

[fdenis]

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

[Rathesh]

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.

[iamabhishek]

A regular expression match like this -

"Test(.*)"

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

[Rathesh]

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

[iamabhishek]

You need to use - (\\s*)