Proper casing for last names like McDonald or IJpelaar etc.

0
Hello, Is there a simple way to program this?  So that the name shows not as Mcdonald (1st is upper case) or MCDONALD (all upper case) or mcdonald (all lower case) but McDonald. Thanks!
asked
2 answers
0

if you really want to do this, you could create a formatting microflow, in which (next to operation to make the first letter uppercase, and whatever else operation you would want) you could do a startsWith(toLowerCase($value), 'mc') check, after which you could change the variable with 3 substring: 1st two characters, 3rd character to which you do a toUpperCase, and the remaining characters.

answered
0

A solution I quite like is to google the name, and use whatever casing occurs most in the first 20 results. Automating this should be very doable.

answered