AnsweredAssumed Answered

Title case via calculation .. how can this be done ?

Question asked by binu.alexander on Feb 23, 2016
Latest reply on Feb 23, 2016 by binu.alexander

I need to convert   TEXT FIELD containing state names eg..  NEW YORK to New York   and FLORIDA to Florida ..

 

I tried the Title Case Text Style .. But that is only at layout formatting level ...

 

I want it to permanently change the field or create a new field via calculation .. How can this be done  ?

 

PROBLEM

 

WHEN I tried to export to excel after using TITLE CASE TEXT STYLE it still remains as  'NEW YORK' ...  The Title case is only a style in Fielmaker it does not permanently change the text ...

Outcomes