Convert Text to Number

media_1449552815383.png

Converts a number in text format to a numeric format.

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

media_1449552825569.png

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

Result – returns the numeric format conversion.

Convert Text to Date

media_1449552766495.png

Converts a date in text format to a date format.

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

media_1449552782465.png

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.

Convert Text Case

media_1449552707638.png

Converts the case of a text phrase.

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

media_1449552729577.png

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.

Remove Leading Ending Spaces

media_1449552655248.png

Removes any leading empty spaces from a text phrase.

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

media_1449552666633.png

Text – the text phrase that will be used.

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

Remove Text Value

media_1449552616516.png

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

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

media_1449552629819.png

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”

Replace Text Value

media_1449552572146.png

Replaces a text value with another value.

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

media_1449552586050.png

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”.

Insert Text Value

media_1449552523260.png

Inserts a text value into an existing phrase.

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

media_1449552536728.png

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”.

Combine Text Values

media_1449552486077.png

Combines two text phrased into one.

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

media_1449552497031.png

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”.

Get Last Position

media_1449552440425.png

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

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

media_1449552451359.png

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.

Get First Position

media_1449552404829.png

Returns the first index of a letter in a string.

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

media_1449552416178.png

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.