Formatting Words from all Caps to standard format

:bullseye: 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.

:thinking: What is the problem & what have you tried?

Previously tried using the Tools module and set variables inserting the values as shown below:

  1. Owner_Clean (LAST,FIRST → First Last)
    startcase(trim(replace(1.owner_name; “,”; " ")))

  2. Address_Clean
    startcase(1.mailing_address)

  3. City_Clean
    startcase(1.mailing_city)

  4. If you have first/last name separately

First name clean

startcase(1.first_name)

Last name clean

startcase(1.last_name)

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

Hello @bitechnologies,

Welcome to the Make community. From this part of your screenshot, I notice that the inline functions that you use are not correct:
Scherm­afbeelding 2026-01-02 om 07.27.00

Make sure that the setup of your functions is like this:


Cheers,
Henk

1 Like

Hello Henk,

This is great. I appreciate the info.