14 Replies Latest reply on Mar 23, 2016 5:37 PM by Chris Gadd

    Any way to create text filters similar to excel?

    taylor.johnson

      Hello,

       

      Problem:  The data in the column that I wanted to filter on contains different data points (fund names) that are essentially a concatenated string.  Excel can get around this by using a text filter and searching for a particular string.

       

      I.E.: Two separate funds (one named AA, the other named BB) both are in the same cell as "AA;BB"

       

      Example Data:

       

                     

      Fund NameProperty Name
      AA;#BBProperty 2
      DD;#AA;#CCProperty 23
      CC;#AAProperty 17
      CC;#DDProperty 21

       

      It would be nice if I could have a regular quick filter that if filtered on "AA" it would return:

       

      Property 2

      Property 23

      Property 17

       

      I have attached a sample workbook as well for reference.