Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Jul 1, 2016

Text Function - Calculated column - InitCap String Function

  • Objective to make the string init caps. Eg. Alpha 
  • We have a workaround where we can take the 1st character of the string and make it upper then append it 
  • it would be great, if we have in built function making first char of a string upper and other chars in lowercase
  • Attach files
  • Admin
    Tobias Lehtipalo
    Jul 3, 2016

    Sounds like you already have a workaround but here´s the expression to use for anyone who has not already figured it out: 

    Concatenate( Upper( left( [ YOUR_COLUMN ], 1) ), Lower( right( [Manufacturer], len( [ YOUR_COLUMN ] ) - 1) ) )