Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter extraction in Query editor

Hi,   I have a column called title that has values like: 1 202 User story 2 2020-2021   I just want to filter titles that have 202. When I use the contain filter, it gives me both the rows sin...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    Try filtering for "202 " , that is a total of 4 characters 202 and a space.

    Or filter to keep 202 and then filter again to remove 20-

    Regards

    Phil

Payeras_BI's avatar
Payeras_BI
Solution Sage
5 years ago

Hi Anonymous ,

A possible code-free solution.

In the example below you need to keep the rows having the substring at the beginning, in the middle or at the end. 

Duplicate the column, split it into rows by each occurrence of the space delimiter and keep only those that are exact matches of your substring.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Payeras_BI loved your solution and it is more robust. However I guess in terms of ease, PhilipTreacy's solution was better. I wonder how I coudn't figure this out on my own, although handing such cases using a space doesnt make sense. I was expecting regex type of solution but a problem solved is a problem solved.