The original statement we have is as follows - Temp001$=“458”
I want to include "459". How should the formula look?
Temp001$=“458, 459"
or
Temp001$=“458” or Temp001$=“459”
The original statement we have is as follows - Temp001$=“458”
I want to include "459". How should the formula look?
Temp001$=“458, 459"
or
Temp001$=“458” or Temp001$=“459”
Thank you
In case your list of values to check keeps growing, here is another way. Let's say valid values are 458, 459, and 460. You can concatenate them and use the POS (scan string) function instead of evaluating with a separate "or" :
POS(Temp001$="458459460") > 0
or even get rid of the "> 0" since that's implied.
Very creative, but you might want to put some blank spaces in between values or you would have success for 458 584 845 459 594 946 and 460.
True! That convention is used in a lot of Sage code but typically for evaluating a limited amount single character values (like an order status being N,O, C, or H)
Interesting indeed. So the correct formula would read? POS(Temp001$="458 459 460") > 0
Yes either space delimited or it could be a symbol (like ^ symbol)
*Community Hub is the new name for Sage City