This content has been marked as final. Show 2 replies
Hi, I have a field in one table structured like this (text is variable length-could be longer characters) :
but I need the result to look like this:
So, the text is 1. capitalized, and that the 2. separator is an underscore and not a dash and also that the 3. text comes before the number portion. The identifier will always be a dash in the field that needs manipulation.
Thanks for your help,