You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

@HspStringCompareArray returns incorrectly

edited Oct 27, 2020 8:29AM in Planning 7 comments

Content

Hi,

I tried using the @HspStringCompareArray function in a business rule which is pretty simple like the example below.

FIX(XXXXX)

"Jan"(

  IF(@HspStringCompareArray(@NAME("Jan"),@NAME("Jul":"Dec"))==1)

    @RETURN("Bingo",ERROR);

  ENDIF

)

I would expect and it should never return the error message because obviously Jan is not present in Jul ~ Dec, however it is returning the error message. Even with IF(@HspStringCompareArray(@NAME("Jan"),@NAME("Jul"))==1) it is returning the error message whis is so weird.  But if I use IF(@HspStringCompare(@NAME("Jan"),@NAME("Jul")))  then it will not go to the return line which is correct.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!