3 Replies Latest reply: May 15, 2014 10:15 AM by Grant Perkins RSS

    strip all characters to the right

    BaWahoo _

      Is there a way to strip all characters to the right of a quote using built-in functions? i.e. strip out all characters to the right of a specified character, in this case a quote.

       

      Data captured: DAYS STAY"  HEADING

      After function is applied: DAYS STAY

       

      Data captured: FC"  IN ('A' THRU 'B'

      After function is applied: FC

       

      Thanks in advance.