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:

       

      If(Left([P/N],1)="B",Substr([P/N],2,17),[P/N])

       

      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....

       

      Thanks,

      Brad Vogl