2 Replies Latest reply: Oct 9, 2014 1:04 PM by Bradl Vogl RSS

    Text Extraction

    Bradl Vogl

      I have a data field that starts with the letter "BB" some of the time.

      I need to remove the first "B".

      If the first character is a single "B" or any other character I need to retain all characters.

      With P/N as the field, I tried:




      This removes the first character if it is a "B"

      I need to remove the first "B" if the fist 2 characters are "B" only


      BB1234      B1234      removes first B

      1234           1234        stays the same

      B1234         B1234     stays the same


      ny help would be appreciated....



      Brad Vogl