Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Did you get a fix? I have similar query.
In response to @AH inquiry, simply use the below for a search string value.
*spare part*
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