Issue in multiple selection

[#1]

Hi,

I have selected action as "select in field"

Field =[Transaction ID]

Search String ='('&replace(vSearch,',','|')&')'

But when I'm giving multiple transaction id's separted by comma and hitting on test. It doesn't work.

Can someone please help me with the error in my button.

Please find the attached screen shot.

Thanks in advance.

Regards,
Adi

[rubenmarin]

Hi Aditya, can you try this?:

Search String ='('&replace('$(vSearch)',',','|')&')'

You can test the expression first in a text box to check the string it returns.

[sunny_talwar]

Try this may be:

='(' & Replace(PurgeChar(vSearch, ' '), ',' , '|') & ')'

[#4]

It didn't work.

[#5]

It didn't work Ruben. But its returning the exact string that I pasted in the text box.

[sunny_talwar]

Will you be able to share a sample application?

Best,

Sunny

[rubenmarin]

I checked one example where I did something similar, I have each value between double quotes, it should be:

Search String ='("'&replace('$(vSearch)',',','"|"')&'")'

[#8]

Hi Ruben,

My search string is correct.

I just removed = before [Transaction ID]. And it's working fine now.

Anyways I appreciate your help.

Thank you.

[rubenmarin]

Ok, I didn't thought that '=' was part of the Field Name.

[#10]

What Aditya meant is to to remove the equal sign before the transaction_id field. see screen shot. it should work.