Capitalise first letter of each word

[mdex83]

I have a free text name field on my form and people like to enter it all CAPS. Rather than add a note to the form I'd like to format it after we get the responses. Is this possible?

I work with people around the world who can have multiple middle names.

Using automate I get the responses from the form both into a spreadsheet and also emailed.

[Expiscornovus · Accepted solution]

Hi @mdex83,

You can use an expression with functions like split, tolower, substring and concat to make the string value lowercase.

Below is an example of that format approach. Hope this helps to get you started?

1. Add a Initialize Variable of type sting, I called it NameField

2. Add a Initialize Variable of type Array, I called it TempArray

Use an expression with a split function in here. I am splitting on a space.

split('JAN PIETER JANSSEN', ' ')

3. Loop through the TempArray array

4. Place an append to string variable action within the loop. Store the result in the NameField string variable. 

Use an expression to make every word lower case with the first letter still in upper case.

concat(substring(item(),0,1),tolower(substring(item(),1,sub(length(item()),1))), ' ')

5. Place a compose outside the loop. This is to show the end result.

 

[mdex83]

Thanks so much Expiscornovus

Only thing I had to change was to add another string variable for NewName as appending to NameField included the original and the corrected.

[mdex83]

Sorry for coming back to this. 

An unexpected entry caused the flow to fail due to the string in the array being only 1 character long, someone entered and initial, even though they're explicitly asked not to.

Unable to process template language expressions in action 'Append_to_string_variable' inputs at line '1' and column '21208': 'The template language function 'substring' parameter is out of range: 'start index' must be non-negative integer and should be less than the length of the string.

Can I somehow amend the expression for this eventuality?

concat(substring(item(),0,1),tolower(substring(item(),1,sub(length(item()),1))), ' ')

[Expiscornovus · Accepted solution]

Hi @mdex83,

Yes, sure 😀

Try this expression instead:

if(equals(length(item()), 1), item(), concat(substring(item(),0,1),tolower(substring(item(),1,sub(length(item()),1))), ' '))

I have added a length equals 1 check. If that is true I only use that first character, the item(). If it is false we are using the concat expression.

[mdex83]

Of course!

I tried using IFERROR instead!

Thanks again