scriptella.core

Class EtlVariable.TextUtils

java.lang.Object

scriptella.core.EtlVariable.TextUtils

Enclosing class:

EtlVariable

public static class EtlVariable.TextUtils
extends java.lang.Object

Utility class for ETL file expressions.

Provides text operations.

Note: As of version 1.1 the same functionality can be achieved by directly using JEXL2.0 syntax elements like ternary operators.

Constructor Summary

Constructors

Constructor and Description
TextUtils()

Method Summary

Modifier and Type	Method and Description
java.lang.Object	ifNull(java.lang.Object object) Substitute an object with empty string when a null value is encountered.
java.lang.Object	ifNull(java.lang.Object object, java.lang.Object replacement) Substitute an object when a null value is encountered.
java.lang.Object	nullIf(java.lang.Object expr1, java.lang.Object expr2) If expr1 = expr2 is true, return NULL else return expr1.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TextUtils

public TextUtils()

Method Detail

ifNull

public java.lang.Object ifNull(java.lang.Object object,
                               java.lang.Object replacement)

Substitute an object when a null value is encountered.

Parameters:

object - object to check.

replacement - replacement object.

Returns:

object or replacement if object==null

ifNull

public java.lang.Object ifNull(java.lang.Object object)

Substitute an object with empty string when a null value is encountered.

Parameters:

object - object to check.

Returns:

object or empty string if object==null.

nullIf

public java.lang.Object nullIf(java.lang.Object expr1,
                               java.lang.Object expr2)

If expr1 = expr2 is true, return NULL else return expr1.

Parameters:

expr1 - first expression

expr2 - second expression

Returns:

true if expr1 = expr2, otherwise null.