This content has been marked as final. Show 2 replies
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....