• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] Connection: Trigger: Run If - search substring in context value

#1 2008-07-14 22:18:38

strpdsnk
Member
Registered: 2008-03-25
Posts: 328

[resolved] Connection: Trigger: Run If - search substring in context value

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

Code:

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

Last edited by strpdsnk (2008-07-14 22:29:57)

Offline

#2 2008-07-14 22:20:03

strpdsnk
Member
Registered: 2008-03-25
Posts: 328

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

******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)

Code:

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

Related Topics
[Forum, topic 1006] Test Not Equal in JAVA Version
[Forum, topic 2112] condition on string



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)


Uploaded Images

Last edited by strpdsnk (2008-07-14 22:33:08)

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] Connection: Trigger: Run If - search substring in context value

Board footer

Powered by FluxBB