Connect CDC SQData

The ISTEXT (Is Text) function determines whether or not a value is a character value. If the value is of a character format, a true (1) is returned. Otherwise, a false (0) is returned.

Category

Boolean

Syntax

ISTEXT(value)

 

Parameter Descriptions

value  -  The value to be tested to determine whether or not it is a character formatted value. The value to be tested can be a field from a source datastore, a variable or the result of another Function. 1 | 0 Indicates whether a TRUE (1) or FALSE (0) was returned from the ISTEXT function.

Example

Determine whether or not an employee’s address (EMP_ADDR) is in character format. If the address is in character format, map it to the corresponding target field. Otherwise, map the constant UNKNOWN to the target field EMP_ADDR.

IF ISTEXT(EMP_ADDR) = 1

{

   TGT_DS.EMP_ADDR = EMP_ADDR

}

ELSE

{

   TGT_DS.EMP_ADDR = 'UNKNOWN'

}