Wildcard search in list box

[satishkurra]

Hi

I have the following requirement.

The data is coming as

03/03/2014-9470-18389-

PK#18389    GL JE#4891

Fixed asset posting US-FA-100018389

PK#18389    GL JE#4970

Orange Intercompany November REV - PK#18389 Consulting

Orange InterCo - December Revenue - PK#18389 Consulting

ReRecord DAX - Adjustment - PK18389

Ideally the user wants to search for the number. That is in this case 18139. There is no proper way of getting the position of this number

If the user search or input 18139, it should select all the values above which contains the value 18139 in a list box.

Can some one help me in achieving this?

I tried below approach of assigning a variable as vTest = '=GetFieldSelections(MyField)'

And an input box to enter the value as 18139 and now a variable event trigger on input for this variable with Select in Field and search string as =if(wildmatch(MyField,'*'&MyField&'*'),MyField)

It did not work...

[tamilarasu · Accepted solution]

Hi Satish,

Have a look at the attached file. I wonder why not ask users to use wildcard search in listbox itself.

The Search String

To enable wildcard search option, check below screenshot.

[satishkurra]

Hi

Thanks for this.

I tried conveying this but no luck.

The problem is there are around 100 values with 18389 which becomes difficult to select all 100 in a list box

[satishkurra]

Also tried the attached app and seems like not working.

[tamilarasu]

What do you mean by not working? When you enter 18139 in the input box, you will see all the matching data in the listbox gets selected. This is your question, right?

[satishkurra]

Yes that is my question

When i select 18139 in input box, nothing is selected in list box

[satishkurra]

Oops. Sorry. I see it selected.

Sorry

[tamilarasu]

No problem . Have a great day.