Transform - Text: Reverse

The Reverse template appears in the template list when a variable length text field, of type nvarchar or varchar, has been picked in the Transform pane.  The template reverses the order of characters in text.  

 

Reverse

Reverse the order of characters in the text and save the result to the specified Result destination.  For example, Netherlands becomes sdnalrehteN.

 

Launch the template by choosing a text field and then double-clicking the Reverse template.  When the template launches we can specify options.

 

Example

We start with a table that has an nvarchar text field called Country, which contains records with the names of countries.  We have used the Layers pane to hide the mfd_id field, for a simpler illustration.

 

 

With the focus on the table, in the Transform pane, the Country field is chosen by default (since it is the only field - we could have chosen it if there were other fields).   We double-click the Reverse template to launch it.

 

 

In the Reverse template, for the Result destination, we choose New Field, and we enter Reversed text as the name of the new field.  We choose the default nvarchar text data type offered for the new field.

 

If we preferred, we could have chosen Same Field for the Result destination, to reverse the text "in place" within the same field.  If the table had other text fields, we could have chosen one of those as the destination.

 

Press Transform.

 

 

The template automatically creates a new nvarchar field called Reversed text and populates it with text from the Country field that has been reversed.

 

 

 

See Also

Transform Pane

 

Transform Reference

 

Transform - Expression

 

Transform - Text

 

Transform - Text: Case

 

Transform - Text: Compose

 

Transform - Text: Concatenate

 

Transform - Text: Copy

 

Transform - Text: Encrypt

 

Transform - Text: Expression

 

Transform - Text: Pad

 

Transform - Text: Reduce

 

Transform - Text: Replace

 

Transform - Text: Trim