2 Replies Latest reply on May 1, 2013 1:17 PM by Chris Smith

    Removing characters from a search string (they were just too funny!)

    Chris Smith

      Hi,

       

      I have a text string question and would be grateful for any support from this community.

       

      Here is my question:

       

      I want to convert this

       

      SEARCH:ABC

      SEARCH:CDEFG

      SEARCH:LMNOP

      SEARCH:QRSTV

       

      To this

       

      ABC

      CDEFG

      LMNOP

      QRSTV

       

      I checked this resource (http://onlinehelp.tableausoftware.com/v7.0/pro/online/en-us/functions_functions_string.html) and also searched the forum without obtaining any ideas. For my data, I don't want to edit the source for this because it would add unnecessary time to my report production time.

       

      Essentially, I want to remove "SEARCH:" from each search string without having to do a delimited text-to-columns in excel.

       

      Thanks and regards!

      Chris