Transform - Text: Expression

The Expression 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 computes the specified SQL expression that evaluates to an nvarchar or varchar data type.

 

Expression

Save the result of the given expression into the specified Result destination, creating new fields using the specified type.

 

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

 

 

 

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: Pad

 

Transform - Text: Reduce

 

Transform - Text: Replace

 

Transform - Text: Reverse

 

Transform - Text: Trim