Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
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
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
Try:
("Sales, Marketing & Relationship"|"Product & Sales")
You have to force the double quotes because there are commas, space, special character, etc
Regards,
Erich
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.
I don't know what happened in your case.
You can check the app I used to try it on the attachment.
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?
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
Thanks a lot. Works fine