Find a value in a keyword field

I have a workflow that is using forms. On these forms the clients have select boxes and these select boxes are merging onto a keyword field when stored. I was wondering if there was a way to find out if a specific word exists in the keyword field, in order to determine the next step. I was wondering if I could populate a variable by using an arithmetic expression using InStr(GV_Variable,"Specific") would this work?

Thanks

Assuming that you read the keyword field out to a keyword variable type, then yes that expression should work.


Phil Robson
Senior Director Client Services, Americas
 

So I have it assigning the data to a keyword value variable. When it gets to the condition check it fails stating "No applicable method 'Instr' exists in type 'Strings'

That seems odd. I can't check the support expression list right now but INSTR is a fundamental method of VB Scripting.

Just for fun, type INSTR all in caps.

But just to be clear, the instr test will return the the numeric position of the first character of the string you are looking for.

Any number above zero means the string is present, 0 means it is not.

Phil

Hmm yeah it is still throwing the same error. Maybe I am missing something, here is what I have set in the condition.

INSTR(1,GV_Kw__SystemAccess,"Evident") =0

I have tried it without the =0 as well just to verify. This is a 7.1 client that is in the cloud, not sure if that matters or not.

Maybe I am adding it incorrectly. I have tried adding this to a condition step and as a arithmetic expression in a data assign step. Both of them state that the method INSTR is invalid for strings.

I figured it out, it is not allowing me to use Instr with a keyword variable, it only is working with Text variables. So I will need to write the keyword index field values into a text variable and then search it for my criteria.

Thanks

Hi Seth,

have you tried to use KeywordAsString?
by using it you do not need to create a variable that could be truncated and you can search for values..

INSTR(1,KeywordAsString(GV_Kw__SystemAccess),"Evident") =0

Regards

I never tried it with the KeywordAsString, but since I can write the keyword values to a text field I just used the INSTR and it works fine. Next time I run across this I will try the KeywordAsString and see if it works.

Thanks