5 Replies Latest reply: Mar 20, 2017 12:06 PM by John Witherspoon RSS

    Modify field value in script

    Jonathan Love

      I have a field I am pulling in that is sometimes prefaced with "SMX", like "SMX0012345"  Often times it is just "0012345"

      What I would like to do in the script is IF LEFT 3 LIKE 'SMX', REPLACE 'SMX' with '77'

      So SMX0012345 becomes 770012345, while 0012345 remains 0012345.

      Thanks in advance.

      JL.