I am have a problem with removing the underscore and replacing with a white space.
Example: Attorney_Notice_Letter_123456-25698-01478
If I use \w+[a-z]
Result: Attorney_Notice_Letter
Could use some help
Thanks
John
Hi John,
Try "Token Calculator" with "SUBSTITUTE"
This will change all your "_" by "" (nothing).
Olivier, I see that your substitute option removes the underscores successfully, but how could we get the underscores to be replaced with a space instead?
Hi Connie,
The Substitude replace old character by new character. In this exemple, it's replacing "_" by "". If you want to replace by space, just change the new character option => "_" by " ".
SUBSTITUTE(%(Token),"oldchar","newchar")
SUBSTITUTE(%(Token),"_","") (replace "_" by nothing)
SUBSTITUTE(%(Token),"_"," ") (replace "_" by space)
Oh my gosh, thank you Olivier! I have been frustrated about the lack of this functionality for years and it's been hiding in Token Calculator this whole time.
Pieter Nauta, you welcome ^^
I made it work! Thanks!