Hello,

I need to set a field calculation so that the contents are uppercase and that the original text format (e.g. in case of copy/paste) is removed.

Is it possible to use both the formulas in the same calculation? (I'm obtaining odd results)

thanks

You can always "nest" functions; the formula is evaluated starting with the innermost function, and the result

is being passed to the next function.

Try

Upper ( TextFormatRemove ( self ) )

An alternative to nesting, especially with complex formulas, is using Let(), e.g.

Let (

asUpper = Upper ( self ) ;

noFormat = TextFormatRemove ( asUpper )

] ;

noFormat

)

which in this simple scenario is sort of overkill, but you can see the principle of having simple expressions pass their result to other simple expression s, in order to reduce overall complexity.