On This Page
advertisement

The transforms in this category perform mathematical functions on values:

Transform Description
mathAdd Adds a number to the value.
mathCeiling Rounds the value to the smallest integer greater than or equal to the value.
mathDivide Divides the value by the given divisor.
mathFloor Rounds the value to the largest integer less than or equal to the value.
mathMultiply Multiplies the value by the given factor.
mathRound Rounds the value to the nearest integer.
mathSubtract Subtracts a number from the value.

Leading Zeroes

To perform math operations, ORA converts text values to numbers and the conversion drops any leading zeroes. For example, if a field named ImageNumber has the value "00183", the result of [ImageNumber:mathAdd:1] is "184".

If you need a number padded on the left with zeroes, use the padLeft transform.

Remove Leading Zeroes

Because ORA converts text values to numbers and that conversion removes leading zeroes, you may use mathAdd to remove leading zeroes without incrementing the number: just add zero! For example, if a field named ImageNumber has the value "00183", the result of [ImageNumber:mathAdd:0] is "183".

Trailing Zeroes

To perform math operations, ORA converts text values to numbers and that conversion drops any trailing zeroes in the fractional part of a real number. For example, if a field named Price has the value "1.20", the result of [Price:mathAdd:1] is "2.2".

As you can see from the example, the trailing zero has been removed. You may want to retain a certain number of digits after the decimal point, or convert numbers with a varying number of digits to the same number of digits by padding with zeroes. Unfortunately, padding to a certain number of digits after a decimal point is not directly supported by an ORA transform and manual methods are tricky. The replace transform will suffice in some cases though its fragile as a general-purpose solution. The basic idea is to use a replacement pattern that matches a value that needs a trailing zero then replace the matching text with the original text and an extra zero.

For example, if you want a field named Rate to have two digits after the decimal point, where some values have two digits ("1.25") and others have one digit ("1.2"), you can match the one-digit values and replace them with the original digit and a trailing zero:

[Rate:replace:(?<v>\.\d)$:$<v>0:g]

The pattern "(?<v>\.\d)$" matches a period followed by a single digit at the end of the Field value. The parentheses and the special "?<v>" notation create a named capture group with the name "v". Typically, we can use capture groups that are automatically numbered sequentially, but in this case, we want to use the capture group followed by a digit in the replacement value. Without using a named capture group, the transform would look like this, and it would not work:

[Rate:replace:(.\d)$:$10:g]

To the Regular Expression parser, "$10" in the replacement value looks like a reference to capture group ten, not a reference to capture group one followed by a zero. To get around that issue, the working example uses a named capture group and that requires the use of "?<v>" to name the group and "$<v>" to refer to it.

mathAdd:number

Adds a number to the value.

If the value or the number is not numeric, returns an empty string.

For example, if a field named ImageNumber has the value "00813", the result of [ImageNumber:mathAdd:1] is "814".

mathCeiling

Rounds the value to the smallest integer greater than or equal to the value.

If the value is not numeric, returns an empty string.

For example, if a field named Age has the value "3.2", the result of [Age:mathCeiling] is "4".

See: mathFloor, mathRound

mathDivide:divisor

Divides the value by the given divisor.

If the value or the divisor is not numeric, or if the divisor is zero, returns an empty string.

For example, if a field named Weeks has the value "18", the result of [Weeks:mathDivide:4] is "4.5".

mathFloor

Rounds the value to the largest integer less than or equal to the value.

If the value is not numeric, returns an empty string.

For example, if a field named Age has the value "3.2", the result of [Age:mathFloor] is "3".

See: mathCeiling, mathRound

mathMultiply:factor

Multiplies the value by the given factor.

If the value or the factor is not numeric, returns an empty string.

For example, if a field named Weeks has the value "4", the result of [Weeks:mathMultiply:7] is "28".

mathRound

Rounds the value to the nearest integer.

If the value is not numeric, returns an empty string.

For example, if a field named Age has the value "3.4", the result of [Age:mathRound] is "3". If a field named Age has the value "3.5", the result of [Age:mathRound] is "4".

See: mathCeiling, mathFloor

mathSubtract:number

Subtracts a number from the value.

If the value or the number is not numeric, returns an empty string.

For example, if a field named ImageNumber has the value "00813", the result of [ImageNumber:mathSubtract:1] is "812".