Multiple selection using button.

[#1]

I have to select multiple values in a field using button.
I am using this logic:

Field: Product,   and
Search String: '(A|B|C)'

It is working fine but one of my product has name (Product Name) i.e. there is a space in between the names and here the logic fails

'(A|B|C|Product Name)' is not selecting Product Name. What could be the possible logic?

[#2]

Hi:

Try the following  '(A|B|C|Product*Name)'

Thanks,
Narasimha K

[#3]

Thanks Narasimha.

It works but i have another problem. I have the field called Product list where all the products are listed and some of them have space in between. I can not pass the names manually. It has to be dynamic. So is there a way so that the space in between gets converted to *.

[Anonymous · Accepted solution]

Hi

     hope this will help you,

     Use this string function to change the Space into *

     =replace([YourField],' ','*')

Regards

Ashok

[#5]

Thanks Ashok