What is your goal?
I am attempting to take input data that are in names and addresses of all capital letters and revert this to the standard data format of having the first letter capitalized and the rest lower case.
What is the problem & what have you tried?
Previously tried using the Tools module and set variables inserting the values as shown below:
-
Owner_Clean (LAST,FIRST → First Last)
startcase(trim(replace(1.owner_name; “,”; " "))) -
Address_Clean
startcase(1.mailing_address) -
City_Clean
startcase(1.mailing_city) -
If you have first/last name separately
First name clean
startcase(1.first_name)
Last name clean
startcase(1.last_name)


