tFileInputDelimited dynamic filename

[Anonymous]

<p>Hello, how to pass parameter filename to tFileInputDelimited?</p>
<p>I have to parse a file that changes daily, the filename format is <strong>somefile_yyyymmdd.csv</strong></p>
<p>So every day it will have different name</p>
<p>&nbsp;</p>
<p>In tFileInputDelimited, I have to select the file manually?</p>

[Anonymous]

Hello,

Could you please try to use a tFileList component to iterate your somefile_yyyymmdd.csv file in a given directory based on a file mask pattern?

tFileList(*.csv)-->tfileinputdelmited(((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")) )-->output

Best regards

Sabrina

[Anonymous]

Hello,

Depends on when you want to parse it.

If it's the same day you can use in the file name :

"somefile_" + TalendDate.getDate("yyyMMdd") + ".csv"

If you want to parse it one every week, use a tFileList then iterate into a tFileInputDelimited.

Hope it'll help.

[dipanjan93]

Use the below code -

((String)globalMap.get("tFileList_1_CURRENT_FILE")).replace(".csv","")+"_"+TalendDate.getDate("yyyyMMdd")+".csv"