Data in String type can be converted to Date, Decimal, Float, Integer, Time or Timestamp type. You can also perform the following operations:
This operation enables you to specify a prefix and adds it in front of the strings.
Input | Prefix | Output |
---|---|---|
abc | XYZ | XYZabc |
def | XYZ | XYZdef |
This operation enables you to specify a suffix and adds it at the end of the strings.
Input | Suffix | Output |
---|---|---|
abc | XYZ | abcXYZ |
def | XYZ | defXYZ |
This operation converts the string encoding from ascii to zenkaku alphanumeric.
This operation returns either true
or false
depending on whether the string contains the specified substring.
The system performs a case sensitive search of the substring.
Input | Output |
---|---|
Macedonia
The substring to find is 'don'. | true |
Macedonia
The substring to find is 'Don'. | false |
Australia
The substring to find is 'Don'. | false |
This operation enables you to specify a suffix, checks if the strings end with this suffix and returns Boolean values (true or false).
Input | Suffix | Output |
---|---|---|
abc | z | false |
xyz | z | true |
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
Input | US | Mexico |
---|---|---|
US | true | false |
Canada | false | false |
Mexico | false | true |
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
Input | US | Mexico |
---|---|---|
US | 1 | 0 |
Canada | 0 | 0 |
Mexico | 0 | 1 |
This operation enables you to specify a Regular Expression (RegExp) and extract characters from strings according to this expression.
Input | RegExp | Output |
---|---|---|
abcdef | ..(.*) | cdef |
uvwxyz | ..(.*) | wxyz |
This operation enables you to specify a length value and extract the specified number of characters from the beginning of each string.
Input | Length | Output |
---|---|---|
abcdef | 2 | ab |
uvwxyz | 2 | uv |
This operation converts Japanese characters from hankaku katakana to zenkaku katakana.
This operation converts Japanese characters from hiragana to katakana.
This operation returns integers that indicate the first occurrence of the specified value in each string. The search proceeds from left to right. Returning "-1" means that the value cannot be found.
Input | Value | Output |
---|---|---|
Apple | r | -1 |
Berry | r | 2 |
Orange | r | 1 |
Strawberry | r | 2 |
This operation converts Japanese characters from katakana to hiragana.
This operation enables you to specify a length value and extracts a certain length of characters from the end of each string.
Input | Length | Output |
---|---|---|
abcdef | 2 | ef |
uvwxyz | 2 | yz |
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.
Input | Value | Output |
---|---|---|
Apple | r | -1 |
Berry | r | 3 |
Orange | r | 1 |
Strawberry | r | 8 |
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.
Input | Prefix | Length | Output |
---|---|---|---|
abc | Z | 6 | ZZZabc |
defghijk | Z | 6 | defghijk |
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 enables you to specify a Regular Expression (RegExp), checks if the strings match this expression and returns Boolean values (true or false).
Input | RegExp | Output |
---|---|---|
abcd | ...(.*) | true |
ef | ...(.*) | 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:
Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
---|---|---|---|---|
A | B | C | 10 | l |
A | B | C | 10 | m |
A | B | C | 10 | n |
D | E | F | 0 | p |
D | E | F | 0 | q |
The following table shows an example of the output (Separator: "."):
Field 1 | Field 2 | Field 3 | Field 4 | Field 5 |
---|---|---|---|---|
A | B | C | 10 | l.m.n |
D | E | F | 0 | p.q |
This operation displays the Null strings as a specified value, while the other values remain the same.
Input | Value | Output |
---|---|---|
XYZ | XYZ | |
abc | XYZ | abc |
This operation finds a specified keyword from strings and replaces it with a specified string value.
Input | Keyword | Value | Output |
---|---|---|---|
abc | a | Z | Zbc |
def | a | Z | def |
This operation replaces each substring of the string that matches the given regular expression, with the given replacement string.
The search is case sensitive.
Input | RegExp | Value | Output |
---|---|---|---|
Orange | [aeiou] | X | OrXngX |
applE | [aeiou] | Z | ZpplE |
Mangoostan | [aeiou] | X | MXngXXstXn |
MAngoostan | [aeiou] | X | MAngXXstXn |
In the above examples, any occurance of the letters a
, e
, i
, o
or u
are replaced with the specified replacement string.
This operation enables you to specify a suffix and a length value, and extend 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.
Input | Suffix | Length | Output |
---|---|---|---|
abc | Z | 6 | abcZZZ |
defghijk | Z | 6 | defghijk |
This operation trims off the extra spaces, tabs and new lines from the right 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 the start and end of the slice operation.
Input | From, To | Output |
---|---|---|
a/b/c | 1, 3 | /b |
d.e.f | 1, 3 | .e |
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:
Input |
---|
a/b/c |
X/Y |
The following table shows an example of the output (Separator: "/"):
Output |
---|
a |
b |
c |
X |
Y |
This operation enables you to specify a prefix, check if the strings start with this prefix and return a Boolean value (true or false).
Input | Prefix | Output |
---|---|---|
abc | a | true |
def | a | 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 string encoding from zenkaku alphanumeric to ascii.