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]

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,

[Rathesh]

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