Skip to main content
Question

Standardizing Names - Formula Text

  • July 12, 2023
  • 0 replies
  • 196 views
Forum|alt.badge.img+1

Hi All!
Can anyone advise on how I may need to change this formula to account for multiple names?  My goal is to capitalize the first letter of each name. 

In most cases, there are only two names but there could be more than three as well... 

This is my current formula... 

Upper(Left([LAST_NAME],1)) & Lower(NotLeft([LAST_NAME],1)) 

Thanks so much for your help!


------------------------------
Laura Natal
------------------------------
    This topic has been closed for replies.

    • Gary1
    • Registered
    • July 12, 2023

    This should do the trick:

    var text one = Upper(Left(Part ([Name], 1, " "),1)) & Lower(NotLeft(Part ([Name], 1, " "),1));
var text two = Upper(Left(Part ([Name], 2, " "),1)) & Lower(NotLeft(Part ([Name], 2, " "),1));
var text three = Upper(Left(Part ([Name], 3, " "),1)) & Lower(NotLeft(Part ([Name], 3, " "),1));

List(" ", $one, $two, $three)

    Output:

    You can even extend it to support more names by adding more variables and popping them into the List function.



    ------------------------------
    gary
    ------------------------------
    gary
      Terms & ConditionsAccessibility statement