How to select string values from a field using button?

[AH]

Hi,

I have a column in a table which is full of strings. what i want to do is, use a part of string(substring) and use that in the search string box and want to select all the values which has that particular substring. Could anyone help me with this? Btw, I was able to achieve that with putting multiple values in searchstring box i.e, like (A|B|C|D). But I want to use substring not the whole.

I want to take the spare part substring and want to select all the rows which has that particular substring.

Thanks!

Shan

[npatel1]

Did you get a fix? I have similar query.

[BrunPierre]

In response to @AH inquiry, simply use the below for a search string value.

*spare part*

[marcus_sommer]

With advanced searches you will be able to select the wanted values but it's not very comfortable for standard-selections. Better will be to apply an appropriate categorizing within the script, for example something like:

pick(wildmatch(upper(Field), '*SPARE PART*', '.....'), 'Spare Stuff', '....') as Category