Select in Filed Expression

[#1]

I am using Select in Fileld Action and

I need some help with expression to select all the fields in the list box except two of them. For instance I need to select all fields except "ABC" or "SDF"

[erichshiino]

Hi,

Do it using two steps

1- Select ABC and SDF using the action Select in Field (the search string will be (ABC|SDF)

2 -  Use the action selected excluded on the same field.

Regards,

Erich

[#3]

Great, Still I need to exclude two strings:

Products & Services  and

Sales, Market & Relationships

What is the correct syntax? I tired:   Products & Services \ Sales, Market & Relationships

with quotes and without quotes, nothing is working

[erichshiino]

Try:

("Sales, Marketing & Relationship"|"Product & Sales")

You have to force the double quotes because there are commas, space, special character, etc

Regards,

Erich

[#5]

Does not work. Actually if i use only one of these fields I have to type them as is (no any quotes) to make it work. If I put

"Sales, Marketing & Relationship" it does not work.

Sales, Marketing & Relationship without anything works.

So now I need to exclude both of them and could not find the way.

[erichshiino]

I don't know what happened in your case.

You can check the app I used to try it on the attachment.

[#7]

ok, It works on V10, not in 9 that I am using. Your sample did not work on 9. Any other idea how to solve it?

[erichshiino · Accepted solution]

Ok,

Try if with 3 steps:

1 - Select in Field

Search string: * (this should select everything - works on qv10)

2 - Use toggle select

Search String: Sales, Marketing & Relationship

3 - Use toggle select

Search String: Product & Sales

[#9]

Thanks a lot. Works fine