topic Re: Filter CSV file in Talend Studio

Filter CSV file

EYamuthan1667195664 — Fri, 15 Nov 2024 22:24:52 GMT

How can i fiter a csv file from the tfilelist having file name google-

OCT-221028151700.csv

Anonymous — Mon, 31 Oct 2022 06:16:09 GMT

Hello,

You can setup the Filemask as "google-OCT-221028151700.csv" for the component tFileList, thanks

EYamuthan1667195664 — Mon, 31 Oct 2022 06:18:30 GMT

But I need to filter all the files from the folder with those time stamp

Anonymous — Mon, 31 Oct 2022 06:51:27 GMT

Hello,

You can uncheck the button "Use Global Expression as Filemask", and setup the Filemask to

"google-OCT-[0-9]+.csv" as the below

MAnywar — Mon, 31 Oct 2022 16:29:16 GMT

Hi @Aiming Chen , could it also be possible to filter using tJava component?

eg. telling tjava to only process content that contains specific tags (for the sake of xmls) < process>?

So if a file has that tag then it can be processed else dumped and nothing is done, and the next file is read?

Anonymous — Tue, 01 Nov 2022 00:46:08 GMT

That method is also possible, and the job needs to be revised

Best regards

Aiming