Text Functions

With InteractiveCalculator you have access to the Excel text functions your're used to. Notice that you need to use the TRIM functions on the fields to turn them into Text, as they're normally assigned a number value inside formulas.

LEFT( TRIM(' @NumberField '), 2 )

Returns the left 2 characters of the NumberField

RIGHT( TRIM(' @NumberField '), 2 )

Returns the right 2 characters of the NumberField

MID( TRIM(' @NumberField '), 3, 2 )

Returns the 2 characters of the NumberField starting from the 3rd character

LEN( TRIM(' @NumberField ') )

Returns the number of characters of the NumberField

TEXT(@ShortTextAnswer)

Returns the text in the Short/Long Text Answer field or a Formula field that outputs a text instead of a number

"TITLE(@Question)"

Returns the title (label) of the question (must have the outer quotes to be evaluated as a string text)