Hi All,
I've been driving myself crazy with this one. (I know not a very long drive)
Let's say I have 3 strings
AABBBBCC
AABBBBCCC
AABBBBCCCC
What I want is a PSD that subtracts the AABBBB from each string and returns the results:
CC
CCC
CCCC
I can do a Left function and isolate the AABBBB but I can't figure out how to subtract this result from the string.
What I want to do is something like:
MyString - Left(MyString,6) but this doesn't work.
Any suggestions?