AnsweredAssumed Answered

Remove Formatting from Fields

Question asked by BradWieland on Dec 24, 2012
Latest reply on Jul 14, 2013 by afterhours

Title

Remove Formatting from Fields

Post

      

     I want to add this calculated expression to many fields to permanently strip out custom formatting:

TextFormatRemove ( self )

     The problem is, I already have the expression below as a calculation in many of the fields:

     If ( IsEmpty ( text access sku01 ) ; "" ; "$" & If ( text access sku01 ≥ 1000 ; Int ( text access sku01 / 1000 ) & "," ; "" ) & Right ( Int ( text access sku01 ) ; 3 ) & Left ( text access sku01 - Int ( text access sku01 ) + .001 ; 3 ) ) & " US"

     Can I have both expressions for a single field? How do I do that?

Outcomes