0

Convert String to lower case Capitalize First Letter of every word

Gary

August 29, 2012 18:19

None

Follow

need help constructing an expression which converts a string to all lower case then capitalizes the first letter of each word. For example, a last name HERMAN to Herman or a Company Name WORTH INTERNATIONAL to Worth International. 

• Facebook
• Twitter
• LinkedIn

6 comments

• 0
  
  Support August 29, 2012 19:02

  You can use the function transformation ToUpper(). You can find this function under String category in Function Transformations.

• 0
  
  Gary August 29, 2012 19:09

  Ok, so how do I combine the upper function to the first character. Also, what about multiple words within a field (like a company name)

• 0
  
  Support August 29, 2012 19:21

  You can use the Split() function to split into words. Then use Left() to get the first letter and convert it to upper. Take the remainder of the word and use ToLower() and then combine these two.

• 0
  
  Gary August 29, 2012 19:26

  Thanks - a quick example would have been helpful - I will figure it out - thanks again for the hint!

• 0
  
  Mike O'Quinn August 30, 2012 23:34

  Here is an example for a single word: Left(Name,1) +  ToLower(Right(Name, Length(Name) - 1))

   

  I would spread out the flow rather than try to write this in a single expression.  Kinda like this:

   

  

• 0
  
  Gary August 31, 2012 02:30

  Thank you, for First and Last name I used ToUpper(Left(ln,1)) + Substring(ToLower(ln),1)