mutilple search string from field through input box

[#1]

Hi all,

My application has a input box as search box.

i have a field called "Category ID"

Category ID	Rank
US0071243	5
US0062711	3
AE1212121	2
AC0000121	3
CA1201921	3
IN12121211	4

My Question - i want to type any of the available string (category ID) in the input box, For Eg. US00*,AE00* then my straight table should bring both the combinations of  Id's,

like this.

Category ID	Rank
US0071243	5
US0062711	3
AE1212121	2

In Input box i am using variable as vSearch and In Settings -> Document Properties -> Triggers -> Variable Event Triggers -> vSearch

->OnChange -> action as 'select in filed' -> in Field ( i am using  Category ID) and in Search String ( i am using "=if(Len(vSearch)>0,'*|'& vSearch & '|*','')" )

by using this i am able to search single category Id, but if i am using replace i am unable to search multiple search.

Kindly help me asap.

Thanks in Advance.

Yours

Venkat

[#2]

Thanks Robin, It seems to be correct. but when i am try in my qvw file the expression showing error. Can take same example and upload the qvw file. so that i can get it clear understand about it.. Lots of thanks for your help.

[Anonymous]

just test it with a text box,

the parser won't "understand" such strange expressions.

A textbox is a good idea for debugging I think.

[#4]

i am testing in text box only..but i am getting expression error, when i am using this expression ='("$(=Replace('$(INPUT)',',','"|"'))").

[#5]

i am happy if you upload qvw file with your solution.

[Anonymous]

I have uploaded it yet!

[#7]

HI All,

Sorry for the delay to response.. Now i am uploading with my original search and required search.

I need to search  multiple in all the search. where ever i need.

Please find the attachment for more clarification..

Kindly help me.. Thanks in advance.

[#8]

HI Sunny,

Now uploaded qvw file and excel file with data.

Can you help me.

[#9]

Hi Robin,

sorry for the delay, now i uploaded qvw file and excel file with data which i need. your expression is not working for me.

Thanks in advance.

[sunny_talwar]

Still trying to understand how the multiple search will work? If you search something, it should find matches in SAID or _SearchStr?

[Anonymous · Accepted solution]

for your example, the values depend on each other, so if you select the above, you'll  get only the rest with the second selection, this could be desired or not... I don't know