Select on field action for value start with Code except one value

[ghassanaldalati]

Dear All :

I have WHId table with many cods ( x21 - x10 - xx3  - xx1 - d20 - e30 .......)

I am trying to make Select in field action  a way to choose all WHId start with (x) except (xx1)==>[ x21-x10-xx3]

i trying this code

= '(' & Concat({< WHId -= {'XX1'}>}WHId,'|') &'"X*"'')'

olso i try 

( "X*" | -'XX1')

please help me...

[Kushal_Chawda · Accepted solution]

you can use below search string. Where XX1 is the string you want to exclude. you can have multiple exclusion as well with comma separated values like {'XX1','XX2'}

='('&Concat({<Code={"X*"}-{'XX1'}>} chr(34)&Code&chr(34),'|')&')'

[Kushal_Chawda]

or simply below search string in trigger

(X*^XX1)

[ghassanaldalati]

='('&Concat({<WHId={"X*"}-{'XX1'}>} chr(34)&WHId&chr(34),'|')&')'.......((GREAT.....thankyou))

but what chr(34) mean...??

[Kushal_Chawda]

chr(34) holds double quote(") character, basically in the end it generated string like ("X1"|"X2"....)