How to exclude strings from the field using buttons

[AH]

I want to exclude these two string values using the button. I was trying to use this expression but its not working.

"("& concat({<ServiceOrderDesc-={"SPARE PARTS ORDER","spare part needed"}>} Distinct ServiceOrderDesc, '|')& ")'

Its not working. Anyone help me please!

[JonnyPoole]

try this

='(' & Concat( {<ServiceOrderDesc=-{'SPARE PARTS ORDER','spare part needed'}>} distinct  '"' & ServiceOrderDesc & '"','|') & ')'

it will create values like this:

("Value1","Value2") 

..excluding the 2 you wrote out

The double quotes are used in case their are spaces or other special characters in the Values

[AH]

Hey Jonathan,

I appreciate your help but its not working.

Thanks,

Shan

[JonnyPoole]

Oh thats ok.  The expression editor has a bug on the highlighter when you use -= syntax in SET ANALYSIS. You'll notice it says 'ok' right above. Trying hitting OK and let me know the results.

[AH]

It still doesnt work.

Thanks,

Shan

[JonnyPoole · Accepted solution]

Here is the sample off my data.

If you have an app to share i can apply the same to yours.

[AH]

Jonathan,

Thank you very much. Its working now.

Shan

Sorry, I was using an excel file and it was working but now i am using database and its not working now.

Thanks,

Shan