I am little confused if the following can be acomplished with the help of EXAMINE…TRANSLATE statement
Display all the customer names and set the first character of every word into upper case, the rest to lower case and connect separate words by ‘-‘
Input: MR JOHN SMITH
OUTPUT-SAMPLE : Mr-John-Smith
I have done EXAMINE #STRING FOR ’ ’ REPLACE WITH ‘-’. This gives me MR-JOHN-SMITH.
Now how can I only translate the first character of each word to Upper case? If I use TRANSLATE TO LOWER CASE, it will make the entire string to lower case.
Is it possible to translate a specific character to upper case?