4 Replies Latest reply on Jul 11, 2018 9:03 AM by John Oswalt

    Trim a string up to a special character

    Chuck Blechle

      I have a data filed that I need to trim up to a special character.  As can be seen in the examples below I have both numbers and letters and the strings to be trimmed are different lengths.  Is there anyway to trim the string up to the ":"?

       

      1053096:Frzr  fans frost bldup

      1086DB6F:Entire bldg/too warm