Hi - I would like to add a space, but only if the string begins with specific characters "TD"
BUSINESS CASH BACK - 0017
TDCASH BACK - 0001
TDAE PLATINUM - 0010
TDREWARDS - 0014
BUSINESS TRAVEL - 0007
Would like it to be:
BUSINESS CASH BACK
TD CASH BACK
TD AE PLATINUM
TD REWARDS
BUSINESS TRAVEL
I know how to remove the numbers and punctuation, just not sure how to space the TD.
thanks!
Solved! Go to Solution.
Hi @jenner85
I would recommend utilizing the substring function in this case.
In a formula tool, I would use this expression:
iif(Substring([Field1],0,2)="TD", "TD " + Substring([Field1],2), [Field1])
Basically, this checks the first two characters of your string. If they're equal to "TD", then it adds a space and continues with the rest of the string. Otherwise, it keeps the original value.
Hope this helps!