search string on values consisting of more than one word

[rudywelvaert]

Hi,

I have the dimension Classification with following values:

Assimilation

Complementary activity

Core business

Helping Partner

Pensioner

Society

In the Actions of a button I want to pre select certain values of Classification using:

Select in Field

Field:                 Classification

Search string:    ='(Assimilation|Core business|Helping Partner|Pensioner)'

But only the values Assimilation and Pensioner get selected, Core business and Helping Partner are not selected.

Most likely because Core business and Helping Partner consist of two words and Assimilation and Pensioner of one single word.

In an attachment I added SearchString.qvw with the dimension Classification, a listbox showing the values of Classification and a button to pre select the values in Classification

How can I solve this problem without having to change the values of Classification.

Thanks

R.W.

[tresesco]

Just enclose those multi-word strings by double quotes like:

='(Assimilation|"Core business"|"Helping Partner"|Pensioner)'

[rudywelvaert]

Thanks B.