Syntax for converting a string from UPPER case to Proper case?

Erika Spencer

10. Januar 2025 16:24

Is there a way to convert UPPER case to Proper case?

0

• 

  Berend Veldkamp

  16. Januar 2025 13:30

  You mean to convert a field value to ‘proper’ case?  I don't think there is a direct way to do this, but this may be a workaround:

  Upper(Substring([myfield], 0, 1)) + Lower(Substring([myfield], 1))

   

  0
• 

  Erika Spencer

  16. Januar 2025 15:41 Bearbeitet

  Berend Veldkamp   Thank you so much!! This syntax worked for fields with one word, which is great! Any ideas on how to adjust for fields with more than one word? ie: SILVER LAKE to Silver Lake

  0
• 

  Zack Robison

  6. März 2025 16:19

  To do that properly will probably require custom scripting (unfortunately there's no enumeration in the expression builder), but you can combine nested IIF, Substring, CharAt, and Join functions to do this a set number of times.

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.