This operation enables you to specify a prefix and adds it in front of the strings.

This operation enables you to specify a suffix and adds it at the end of the strings.

This operation converts the string encoding from ascii to zenkaku alphanumeric.

Input	Output

This operation capitalizes the first character in each string.

This operation counts the number of characters in each string.

This operation enables you to specify a suffix, checks if the strings end with this suffix and returns Boolean values (true or false).

Before starting this operation, you must specify nominal or ordinal attributes for the specified field in a processor. These attributes should be values from the field. Create another processor for this operation, and link these 2 processors with the Flow connector.

This operation generates one or more new fields in Boolean type depending on the attributes. New field names will be the same with attribute names. If a row value equals the attribute value, it returns "true". Otherwise it returns "false".

The following table shows an example when the nominal or ordinal attributes are:

US
Mexico

Before starting this operation, you must specify nominal or ordinal attributes for the specified field in a processor. These attributes should be values from the field. Create another processor for this operation, and link these 2 processors with the Flow connector.

This operation generates one or more new fields in Integer type depending on the attributes. New field names will be the same with attribute names. If a row value equals the attribute value, it returns "1". Otherwise it returns "0".

The following table shows an example when the nominal or ordinal attributes are:

US
Mexico

This operation enables you to specify a Regular Expression (RegExp) and extracts characters from strings according to this expression.

This operation enables you to specify a length value and extracts a certain length of characters from the beginning of each string.

This operation converts Japanese characters from hankaku katakana to zenkaku katakana.

Input	Output

This operation converts Japanese characters from hiragana to katakana.

Input	Output

This operation returns integers to find out where is the first occurrence of the specified value in each string. Returning "-1" means that the value cannot be found.

This operation converts Japanese characters from katakana to hiragana.

Input	Output

This operation enables you to specify a length value and extracts a certain length of characters from the end of each string.

This operation returns integers to find out where is the last occurrence of the specified value in each string. Returning "-1" means that the value cannot be found.

This operation enables you to specify a prefix and a length value, and extends the length of strings by repeating the prefix from the left end. If the specified length is smaller than the original length, strings are unchanged.

This operation trims off the extra spaces, tabs and new lines from the left end of strings. For example, you can left trim the string " 2011-10-31" and receive the output "2011-10-31".

This operation converts the uppercase letters into lowercase.

This operation enables you to specify a Regular Expression (RegExp), checks if the strings match this expression and returns Boolean values (true or false).

This operation merges strings from the specified field by connecting them with a separator, when the corresponding rows from the other fields include exactly the same information. These rows will become one row as a result of merge.

The following table shows an example of the input:

The following table shows an example of the output (Separator: "."):

This operation displays the Null strings as a specified value, while the other values remain the same.

This operation finds a specified keyword from strings and replace it with a specified string value.

This operation enables you to specify a suffix and a length value, and extends the length of strings by repeating the suffix from the right end. If the specified length is smaller than the original length, strings are unchanged.

This operation trims off the extra spaces, tabs and new lines from the right end of strings. For example, you can right trim the string "2011-10-31 " and receive the output "2011-10-31".

This operation enables you to specify two integer values, which indicate from where you start the slice operation and to where you end it.

This operation splits strings according to a specified separator, and displays the split characters in separate rows.

The following table shows an example of the input:

The following table shows an example of the output (Separator: "/"):

This operation enables you to specify a prefix, checks if the strings start with this prefix and returns Boolean values (true or false).

This operation trims off the extra spaces, tabs and new lines from both ends of strings. For example, you can trim the string " 2011-10-31 " and receive the output "2011-10-31".

This operation converts the lowercase letters into uppercase.

This operation converts the string encoding from zenkaku alphanumeric to ascii.

Input	Output

This operation converts Japanese characters from zenkaku katakana to hankaku katakana.

Input	Output