3 Replies Latest reply on Dec 13, 2016 10:22 AM by David Li

    Tableau calculation that will only select entries that contain an exact string?

    stephen.cavallaro.0

      For instance: I am searching for the string TOMS, but I am pulling in strings with the word SYMPTOMS. Of course that string contains TOMS but I need TOMS by itself (not completely, could be part of a sentence, but not a portion of a word.)

       

      On another data source I employ the following sql to get the desired results: regexp_like(column_name, '(^|\s)toms(\s|$)', 'i');

      (I cannot alter the sql for the current data source, so my calculation must be in Tableau)

       

      Thank you.