Link to home
Start Free TrialLog in
Avatar of rowfei
rowfei

asked on

Select Expert use "Like" formula with multiple values parameter

I have one parameter have to setup for use to enter multiple values. In the Select Expert, I am using "Like" formula below and keep getting the error message.

{Command.Code} like "*" & {?CodeSet} & "*"

How can I make this like formula works with parameter with multiple values?

Thanks,
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rowfei
rowfei

ASKER

Thanks, all.

mlmcc- I do have another criteria in the formula (works fine since this parameter is not multi-value). Please see it below.

{Command.Code1} Like "*" & {?CodeSet1} & "*"

How to combine it with your codes below together?

Local NumberVar Index;
Local BooleanVar bResult := False;

For Index := 1 to UBound({?CodeSet}) do
    bResult := bResult OR ({Command.Code} like "*" & {?CodeSet}[Index] & "*";
bResult

Thanks again!!!
Not sure you can directly.

Try this


{Command.Code1} Like "*" & {?CodeSet1} & "*"
AND
{@yourFormula}

mlmcc