Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Jul 1, 2016

RELATED IDEAS

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

    Reply
The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group, Inc. All rights reserved