Search String Format

[MallikarjunaG]

Hi All,

I have scenario like data values are like

ProdA|ProdB

Prodc|

ProdE|ProdE

I am providing input box for users to paste the list of values into input to search through column through button action

I was able do it if the column value is having single value , but the same search string format not working for above data format, knidly help me with search string format to be used in button action 

Thanks & Regards

Mallikarjun

[robert_mika · Accepted solution]

1. Use a expression to split string into single inputs 

2.Create then action using the option 'Select values matching search criteria'

with a sting like ='(" ' Product('$(vProd1)')&'"|"'&Product('$(vProd2)')&' ")'

[Chanty4u · Accepted solution]

Try this 

You can use 

LOAD

    ID,

    SubField(ProductField, '|') as Product

FROM Source;

So that you can use normal search.

Or

Try this 

*$(vInputValue)*

[MallikarjunaG]

Hi Both,

have to use both of your inputs to make it work,

Thank you for your help

Regards

Mallikarjuna