Table of Contents

Mirror(text)

Category: Text function


Description

This function returns a string with the reverse order of characters in text.


Use cases

This function allows for using text functions such as KeepBefore and KeepAfter to operate with the last occurrence of a substring in a text value. Refer to the example below.


Arguments

ArgumentTypeDescription
textTextAny text value, or value that can be implicitly converted to text.

Return value type: Text


Remarks

Number values entered for text are implicitly converted to text.

The case of characters is retained in the mirrored return value.


Examples

mirror('New Jersey') //Returns 'yesreJ weN'
mirror('Toronto') //Returns 'otnoroT'
mirror(123456) //Returns '654321' (Number implicitly converted; value returned as text.)


Allows the use of KeepAfter on the last instance of the specified character '-'. (Spaces added for clarity.)

mirror( keepafter( mirror('one-two-three'), '-') ) //Returns 'one-two'