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

This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us