8 Replies Latest reply on Jul 12, 2018 11:10 AM by Jenni Davila

    Remove a letter from a number

    Jenni Davila

      Hello everyone,

       

      I've found many ways to parse a string variable but none that allow me to address this issue. I have a field that occasionally has a letter added to either the beginning or the end of an otherwise 3-digit number. I am trying to find a way to remove the letter, whether it be in the beginning or the end, and retain the numerical value.

       

      Example.

       

      CurrentDesired
      204T204
      S570570