Talend community forum / How to set a wildcard for file name of tFileinputDelimited

yuya · 2011-09-22 12:57:16

Hi,
Please tell me my question.
Has Talend a wildcard such as VBA's "*" or oracle's "%"?

What I wanna do is like following.

e.g
tFileinputDelimited FIleName in job : "com/sale*.csv"

Thanks!
Regards,

vgalopin · 2011-09-22 17:31:19

Hi Yuya,

You would have to use a tFileList component to return a list of files matching your wildcard, and then in the tFileInputDelimited use the file name returned by the tFileList to use it as an input.

You can drag and drop the tFileList component in your job design and press F1 if you want more information about it.

yuya · 2011-09-27 09:51:07

Hi vgalopin,

Thank you for your replay.
but I have make other error.
When I use a tFileList component for xls files in a directory to return this file name to tFileInputExcel component's file name.
Although this component could not find the file I want.

Following are error scripts:

[Exception in component tFileList_1
java.lang.RuntimeException: No file found in directory //Server's IP/TEST
at online_sales_job.ebs_0_1.SAMPLE.tFileList_1Process(SAMPLE.java:1592)
at online_sales_job.ebs_0_1.SAMPLE.runJobInTOS(SAMPLE.java:1904)
at online_sales_job.ebs_0_1.SAMPLE.main(SAMPLE.java:1772)]

Why this component could not find the file?
And It could find that when file type in a directory was "csv".
Could you please tell me about this case.

Thanks!
Regards,

shong · 2011-09-27 10:07:31

Hi
How do you set the file mark? it should be something like "*.csv" or "*.xls"

Best regards
Shong

Announcement

Unanswered posts

#1 2011-09-22 12:57:16

How to set a wildcard for file name of tFileinputDelimited

#2 2011-09-22 17:31:19

Re: How to set a wildcard for file name of tFileinputDelimited

#3 2011-09-27 09:51:07

Re: How to set a wildcard for file name of tFileinputDelimited

#4 2011-09-27 10:07:31

Re: How to set a wildcard for file name of tFileinputDelimited

Board footer