I have the following If expression that I'm trying to use as a calculated dimension in a straight table. What I'm trying to do is if starting in position 4 for the rest of the string if SUBLOB equals 'AAA Shared Tech', then set SUBLOB = BBB, otherwise, starting in position 4 give me the rest of the string. Here's the If:
This is a bit embarrassing, but your solution actually does work and I will mark your response as the correct one. I had another problem with my If expression in that I was using the wrong starting position for the mid function. Instead of starting at 4, it should have been 5. My apologies for any inconvenience. Thank you for your help.