Forum Discussion

LauraNatal's avatar
LauraNatal
Qrew Member
10 months ago

Standardizing Names - Formula Text

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
------------------------------

2 Replies

Sort By
  • Gary1's avatar
    Gary1
    Qrew Cadet
    10 months ago

    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
    ------------------------------
    • LauraNatal's avatar
      LauraNatal
      Qrew Member
      10 months ago

      Thanks so much!!! Worked great!!



      ------------------------------
      Laura Natal
      ------------------------------