Connection: Trigger: Run If - search substring in context value

Anonymous — Sat, 16 Nov 2024 14:17:57 GMT

******NEVERMIND******
of course, after trying everything i could think of for like an hour, I figure it out right after I post the problem:

StringHandling.INDEX(context.FileMask,"Option")>0

Re: Connection: Trigger: Run If - search substring in context value

Anonymous — Mon, 14 Jul 2008 21:20:03 GMT

******Original Post(s)******
I want to search a context variable value for a substring, and run a job if the substring exists in the context variable value. But I'm having trouble getting the right logic to make that happen
The only thing that allowed tRunJob_2 or tRunJob_8 ran both of them (see pic #5)

Relational.NOT(Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option")))

Related Topics
1006
2112

Here is a list of other things I have tried, and the errors I've gotten:
StringHandling.INDEX(context.FileMask,"Option")

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
Type mismatch: cannot convert from int to boolean
Type mismatch: cannot convert from int to boolean
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)

StringHandling.INDEX(context.FileMask,"Option") != null

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The operator != is undefined for the argument type(s) int, null
The operator != is undefined for the argument type(s) int, null
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)

Relational.NOT(Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option"))) = TRUE

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The left-hand side of an assignment must be a variable
The left-hand side of an assignment must be a variable
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)

Relational.NOT(Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option"))) == TRUE

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
TRUE cannot be resolved
TRUE cannot be resolved
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:432)

Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option"))!=0

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The operator != is undefined for the argument type(s) boolean, int
The operator != is undefined for the argument type(s) boolean, int
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)

Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option"))>0

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The operator > is undefined for the argument type(s) boolean, int
The operator > is undefined for the argument type(s) boolean, int
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)

Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option"))<0

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The operator < is undefined for the argument type(s) boolean, int
The operator < is undefined for the argument type(s) boolean, int
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)

Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option"))==1

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The operator == is undefined for the argument type(s) boolean, int
The operator == is undefined for the argument type(s) boolean, int
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)

Re: Connection: Trigger: Run If - search substring in context value

Anonymous — Mon, 26 Dec 2016 07:13:41 GMT

error

topic Re: Connection: Trigger: Run If - search substring in context value in Talend Studio

Connection: Trigger: Run If - search substring in context value

Re: Connection: Trigger: Run If - search substring in context value

Re: Connection: Trigger: Run If - search substring in context value