Forum Discussion
Solved
Filtering on Text
Hi All, How can I filter all the rows that contain text LOC in the Risk Categories column as shown in a table below? I have tried using ? or * as wildcards text but they did not work.
MelbourneBadger Ohhhhhh... I did not get that from your original post, I was misled by the picture and just thought you were trying to filter the data view. OK, in that case you need to use FIND, SEARCH or CONTAINSTRING. So, something like:
New Table = FILTER('Old Table',FIND("LOC ",[Column],,0) <>0)
MelbourneBadger Ohhhhhh... I did not get that from your original post, I was misled by the picture and just thought you were trying to filter the data view. OK, in that case you need to use FIND, SEARCH or CONTAINSTRING. So, something like:
New Table = FILTER('Old Table',FIND("LOC ",[Column],,0) <>0)
Superb Greg_Deckler ! Thank you very much. That's exactly what I needed.