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

[sunny_talwar]

but if i am using replace i am unable to search multiple search.

Using replace?

[Anonymous]

Why don't you just use a Listbox and fill with a search string like that?:

(US00*|AE00*)

for example?

[#4]

Hi Sunny, Thanks for reply... Can you send me the expression.

[sunny_talwar]

I am still not sure what you are looking to get. May be try roharoha‌'s response?

[#6]

Hi Robin, Thanks for reply.. I don't want to change it to list box.. its already developed dashboard and In home page only we are providing the search option. based on the search only the resultant dashboard will shown to the user.. can you try it in input box only.. thanks for your suggestion.

[#7]

i will post my sample qvw file soon.. so that you can understand..

[sunny_talwar]

Sounds good

[german24]

I hope help you whit this,

//Create a Category for each "Category ID" and you will can used that field

Category:

LOAD Distinct

     [Category ID],

     Left([Category ID],2) AS Category     //New field (contains for example: 'US', 'AE')

Resident Tabla;     //Where is the field "Category ID"

Best regards,

German

[Anonymous]

... select in field:

='("$(=Replace('$(INPUT)',',','"|"'))")