Chapter 2. Boolean and String Transforms

Table of Contents

Boolean Transform
And
Discard
Not
Or
Retain
To either
String Transform
Add prefix
Add suffix
Ascii to zenkaku alphanumeric
Capitalize
Count
Ends with
Enumeration to boolean
Enumeration to integer
Extract
First
Hankaku katakana to zenkaku katakana
Hiragana to katakana
Index of
Katakana to hiragana
Last
Last index of
Left pad
Left trim
Lower
Matches
Merge
Null to string
Replace
Right pad
Right trim
Slice
Split
Starts with
Trim
Upper
Zenkaku alphanumeric to ascii
Zenkaku katakana to hankaku katakana

Boolean Transform

Data in Boolean type can be converted to String or Integer (1 for "true", and 0 for "false"). You can also perform the following operations:

And

This operation applies to at least two selected fields. It follows the logical operation rules for the "And" operator. After selecting the field to operate on, specify other field names following the "A,B,C" syntax.

Field AField BOutput
truetruetrue
falsetruefalse
truefalsefalse
falsefalsefalse

Discard

This operation discards the rows that contain the "true" value in the selected field.

The following table shows an example of the input:

Field 1Field 2
1false
2true
3true
4false

The following table shows the output:

Field 1Field 2
1false
4false

Not

This operation applies to at least two selected fields. It follows the logical operation rules for the "Not" operator.

InputOutput
truefalse
falsetrue

Or

This operation applies to at least two selected fields. It follows the logical operation rules for the "Or" operator. After selecting the field to operate on, specify other field names following the "A,B,C" syntax.

Field AField BOutput
truetruetrue
falsetruetrue
truefalsetrue
falsefalsefalse

Retain

This operation retains the rows that contain the "true" value in the selected field.

The following table shows an example of the input:

Field 1Field 2
1false
2true
3true
4false

The following table shows the output:

Field 1Field 2
2true
3true

To either

This operation enables you to specify new values (for example, "Yes" and "No", or "Success" and "Fail") for "true" and "false", and displays the result according to your input.

InputValuesOutput
truetrue="Yes", false="No"Yes
falsetrue="Yes", false="No"No