Trim Text Action


<AMTEXTREMOVE TEXT="text" REMOVE="text" CHARACTERS="text" ACTION="text [options]" RESULTVARIABLE="text [varibable name]">

See Also

Trim Text Action-Setting Properties, Insert Text Action, Find Text Action, Get Subtext Action


Removes characters from the beginning and/or end of the specified text and places the result in a variable..

Practical Usage

Text manipulation. Used to take spaces off of the beginning or end of a value text value. These spaces can sometimes be cause by data-entry error or a formatting routines from external applications.


General Tab

Text to Remove from

Text, Required
MARKUP: TEXT="    text padded with spaces "

Specifies the text to trim.  

Remove from

Text [options], Optional (default: beginning and end)
MARKUP: ACTION="remove_beginning"

Specifies how the text is trimmed.

The available options are:


Text [options], Optional - Default: Whitespace
MARKUP: REMOVE="returns"

Specifies the character(s) to remove from the string.

The available options are:

Characters to Remove

Text, Required if Remove is "user"

If Remove is set to User Defined, specifies the user defined characters to remove..

Populate Variable with Result

Text [variable name], Required

Specifies the variable to receive the new formatted value.


Using Variables

All variables must be created before they can be used. This is done using the Create Variable <AMVARIABLE> action. Once created, variables can be set using the Set Variable <AMSET> action, or by certain actions that support populating variables. To get data out of the variables, in any action parameter, simply surround the variable name with percentage % signs (e.g. %varname%). Remember not to use percentage signs when specifying the name of a variable to populate, percentage signs are only needed to get data out.

Custom Description

This action includes the Description tab for entering a custom step description.

More on setting custom step description

Standard Error Handling Options

This action also includes the standard Error Causes and On Error failure handling options/tabs.

More on Error Handling Options

Variables and Expressions

All text fields allow the use of expressions, which can be entered by surrounding the expression in percentage signs (example: %MYVARIABLE%, %Left('Text',2)%). To help construct these expressions, you can open Expression Builder from these fields by pressing F2.

More on variables
More on expressions

More on the expression builder


NOTE: The code below can be copied and pasted directly into the Steps pane of the Task Builder.

<AMVARIABLE NAME="thevariable">  this text has spaces on the front</AMVARIABLE>
<AMTEXTREMOVE TEXT="%thevariable%" RESULTVARIABLE="thevariable">