String

Wraps the argument in double quotes. Mainly used to specify string values that can be used as input in other blocks.

“”

A letter, word, or line of text.

A string.

The following example returns “California”:

Script:

Text

Character

Returns a string representing the ANSI character corresponding to the ASCII code (0-255) that is supplied as an integer parameter.

Char(parameter)

Any valid integer that corresponds to the ASCII code (0-255).

A string representing the ANSI character corresponding to the integer parameter.

The following example returns the string “A”:

Script:

Text

Clean

Removes all non-printable characters from a string.

Clean(parameter)

A valid string or a string expression.

The specified string with all non-printable characters removed.

The following example returns a string after removing all non-printable characters from the source field:

Script:

Text

Concatenate

Creates a single string by joining two or more individual strings.

(For two strings)

operand1 & operand2

(For two strings)

operand1 – A string value.

operand2 – A string value.

A string which is a result of concatenation of two or more individual strings.

The default number of strings that you can concatenate is two. To increase the number of strings do the following:

The following example returns a string (full_name) after concatenating two string fields “first_name” and “second_name”:

Script:

Text

Length

Returns the number of characters (including spaces) in the provided String.

Len(parameter)

A string.

An Integer that represents the count of characters in the argument string.

The following example returns “10”.

Script:

Text

Change Case

Converts the input string to UPPER, lower, or Title case based on the option that you select from the drop-down:

Upper(parameter)

Lower(parameter)

Proper(parameter)

A string.

An UPPER, lower, or Title case string.

The following example returns “CALIFORNIA”.

Script:

The following example returns “california”.

Script:

The following example returns “California”.

Script:

Text

Trim

Removes spaces from the beginning, end or both sides of a string, based on the option that you select from the drop-down:

Trim(parameter)

TrimLeft(parameter)

TrimRight(parameter)

A string.

The specified string with spaces removed from the beginning, end or both sides of a string, based on the selected trim option (Left, Right, Both).

The following example returns “Test String” after removing the leading and trailing spaces from the string:

Script:

Text

Reverse

Returns the reverse of a string.

Reverse(parameter)

A String or a string expression.

The reverse of the string that is specified as the parameter.

The following expression returns “gnirts” (“string” reversed):

Script:

Text

Character Count

Counts the occurrences of a particular character in a string.

CharCount(character, string)

character - The character to look for and count. This is case-sensitive. Hence, if the specified character is in lower case, then the count will be of lowercase character.

string - The string where to search.

An integer that represents the number of occurrences of a character in a string.

This example returns the number of spaces in the first source field. The name "John Thompson Reynolds" would return 2.

Script:

Text

Extract Characters

Extracts characters of a specified type from a string.

Extract(string, charType)

string – The string to extract from.

charType – The type of character that you want to extract. You can select from “Alphabetic”, “Numeric” and “Alphanumeric”.

charType is “Alphabetic” - All alphabetic characters from the specified string.

charType is “Numeric” - All numeric characters from the specified string.

charType is “Alphanumeric” - All alphanumeric characters from the specified string.

This example returns “Thisisexample”, “437”, and “Thisisexample437” when you select “Alphabetical”, “Numeric”, and “Alphanumeric” respectively:

Script:

Text

Replace All

Replaces every occurrence of a specific “String” with the “Replacement” string in the specified search string.

Replace(string, replacement, match)

string – The string where to search.

replacement – The replacement string.

match – The matching pastern (the string to be searched).

A string.

Replace All recognizes all special characters in the “match” parameter, but they must be preceded by the escape character backslash “\”. For example if you want to find and replace parentheses specify “\(”.

The following example replaces every occurrence of "Fri." with "Friday" in the “field1” field:

Script:

Text

Left

Extracts the specified number of characters from the beginning of a given string.

Left(string,length)

string – The string to extract from.

length – The number of characters to extract. Must be a positive number.

Returns a string.

The following example returns four characters from “Field1” starting from the beginning. For example if “Field1” is “44060-1930” then the returned value is “4406”.

Script:

Text

Right

Extracts the specified number of characters from the end of a given string.

Right(string,length)

string –The string to extract from.

length – The number of characters to extract. Must be a positive number.

Returns a string.

The following example returns four characters from “Field1” starting from the end. For example if “Field1” is “44060-1930” then the returned value is “1930”.

Script:

Text

Mid

Extracts the specified number of characters from a given string, starting from a specific position.

Mid(string,start,length)

string – The string to extract from.

start – The start position. The first position in the string is 1.

length – The number of characters to extract. Must be a positive number.

Returns a string.

The following example returns four characters from “Field1” starting from seventh position. For example if “Field1” is “44060-1930” then the returned value is “1930”.

Script: