topic Re: Trigger Run If Java Condition - How to code not contains in Talend Studio

Trigger Run If Java Condition - How to code not contains

Edith1 — Thu, 24 Sep 2020 17:20:22 GMT

Hello I am using this code for Trigger Run If to determine if the file format is .csv to run a component. ((String)globalMap.get("FileName")).contains(".csv")

How can I code for everything else? Is there a java code to check if Not Contains .csv?

Re: Trigger Run If Java Condition - How to code not contains

Anonymous — Fri, 25 Sep 2020 03:39:17 GMT

How does the file name come? Do you use a tFileList to iterate a folder? Can you please explain why you use the global available?

(String)globalMap.get("FileName")

Regards

Shong

Re: Trigger Run If Java Condition - How to code not contains

vikramk — Fri, 25 Sep 2020 06:33:10 GMT

Hi Edith,

If you don't mind, could you share a snapshot of your job design which you are trying to achieve. It helps us to know the requirement.

Re: Trigger Run If Java Condition - How to code not contains

Edith1 — Fri, 25 Sep 2020 16:08:03 GMT

Here's a screenshot of the job. In the beginning of the job, I'm iterating a temp table that includes the FileName to the tRestClient. The FileName has the file format of .csv or .xls. If the FileName contains .csv, then it goes to tFileRowCount and prints the message in tJavaFlex. If the FileName contains something else other than .csv, then I only want to print the message.

Re: Trigger Run If Java Condition - How to code not contains

Anonymous — Sat, 26 Sep 2020 03:16:27 GMT

Thanks for sharing your job, it is clear now. To get the current value of FileName column, the expression is:

(String)globalMap.get("rowN.FileName")

rowN is the row identifier such as row1 before tFlowToIterate

The java code to check if Not Contains .csv is:

!((String)globalMap.get("rowN.FileName")).contains(".csv")

Regards

Shong

Re: Trigger Run If Java Condition - How to code not contains

cadap — Wed, 30 Sep 2020 20:17:23 GMT

Hi,

contains() returns a boolean type.

In you case, if the filename contains ".csv", the expression returns true.

If I understood you correctly, you want every other file than .csv, so all files, that do not contain ".csv"?

Simply type:

!((String)globalMap.get("FileName")).contains(".csv")

Notice the exclamation mark. It means "not".

Re: Trigger Run If Java Condition - How to code not contains

Edith1 — Thu, 08 Oct 2020 21:29:47 GMT

Thank you @Bernhard Gruber for your time and help!