Publicado Thu, 26 Sep 2019 19:46:58 GMT por Seth Jaco Support Specialist
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
Publicado Thu, 26 Sep 2019 19:50:25 GMT por Phil Robson DocuWare Corporation Senior Director Client Services, Americas
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
 
Publicado Thu, 26 Sep 2019 20:01:18 GMT por Seth Jaco Support Specialist
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'
Publicado Thu, 26 Sep 2019 20:32:16 GMT por Phil Robson DocuWare Corporation Senior Director Client Services, Americas

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

Publicado Thu, 26 Sep 2019 20:53:13 GMT por Seth Jaco Support Specialist
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.
Publicado Fri, 27 Sep 2019 13:18:21 GMT por Seth Jaco Support Specialist
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.
Publicado Fri, 27 Sep 2019 13:39:21 GMT por Seth Jaco Support Specialist
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
Publicado Tue, 01 Oct 2019 16:23:52 GMT por Bruno Villa
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
Publicado Fri, 04 Oct 2019 13:45:40 GMT por Seth Jaco Support Specialist

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

You must be signed in to post in this forum.