Category: Automation Text Actions

Converts a number in text format to a numeric format.

Click the Click for Options link to bring up the Options dialog.

Text – the number in text format. Must be numeric.

Result – returns the numeric format conversion.

Converts a date in text format to a date format.

Click the Click for Options link to bring up the Options dialog.

Text – the text value that will be used for conversion. This must be a text phrase in a valid date format.

Result – returns the date conversion.

Converts the case of a text phrase.

Click the Click for Options link to bring up the Options dialog.

Text – the phrase that will be used in the conversion.
Type – the type of conversion to be performs (To Lower, To Upper, To Title).

Result – returns the converted text phrase.

Removes any leading empty spaces from a text phrase.

Click the Click for Options link to bring up the Options dialog.

Text – the text phrase that will be used.

Result – the text phrase with any leading empty spaces removed.

Removes a character or a group of characters from a text phrase.

Click the Click for Options link to bring up the Options dialog.

Text – the phrase that will be used.
Count – the amount of characters that will be removed.
Index – the starting point of the removal with 0 being the first character.

Result – return of the phrase after the removal.

Example: We wil remove the “will from the text phrase has “I will jump over the fence”. The “w” has an index of 2 and there are 4 characters plus an empty space in “will”.

Text = “I will jump over the fence.
Count = 5 (the word will contains 4 characters and we will also remove the empty space after will).
Index = 2 (0 starts with I)
Result = “I jump over the fence”

Replaces a text value with another value.

Click the Click for Options link to bring up the Options dialog.

Text – the text phrase that will be used.
Value – the initial value to be searched within the text phrase.
Replacement – the phrase that will be used to replace the Value.

Result – returns the final text phrase after the replacement happens.

Example: The Text phrase is “My dog is a black lab”. The Value we will use to search will be “black”. The replacement value will be “yellow”. The result will be “My dog is a yellow lab”.

Inserts a text value into an existing phrase.

Click the Click for Options link to bring up the Options dialog.

Text – the existing phrase that will be inserted into.
Value – the text phrase that will be used in the insertion.
Index – the starting point of the insertion with 0 being the first character of the Text field.

Result – the completed phrase after the insertion.

Example: Using the Text phrase of “Little House Prairie” and the Value of ” on the “. If the index to start the insertion is 12, the final phase would be “Little House on the Prairie”.

Combines two text phrased into one.

Click the Click for Options link to bring up the Options dialog.

First – the text phrase that will be in the first position.
Second – the text phrase that will be in the last position.
Add Space – true if a space will be added between phrases, false if no space will be added.

Result – the combination of both phrases.

Example: The First phrase is “Book” and second is “Mark with Add space set to true will result in “Book Mark”. The add space set to false will result with “BookMark”.

Find the location of the last occurence of a letter of phrase.

Click the Click for Options link to bring up the Options dialog.

Text – the text phrase that will be checked.
Value – the letter or phrase to be used in the check.

Result – returns the last position of the phrase used or a -1 if the phrase wasn’t found.

Returns the first index of a letter in a string.

Click the Click for Options link to bring up the Options dialog.

Text – the text phrase to be checked.
Value – the value that will be used to check.

Result – return the index of the first use of the value or a -1 if the value is not found.