Validating Strings
To change Validation Function properties double click on it
Is Null
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is equal to null. |
| Properties | Default |
Is Empty String
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is Empty String. (Length of the string is zero) |
| Properties | Default |
Is Null or Empty String
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is Is Null or Empty String. (Length of the string is zero) |
| Properties | Default |
Is Alpha
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data contains only Alpha characters |
| Properties | Default |
| Pass | FCD,mmm,ABC |
| Fail | adc1,ad b,12 D |
Is Alpha Numeric
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data contains only Alpha Numeric characters |
| Properties | Default |
| Pass | FCD12,mm11m,1ABC |
| Fail | adc-1,ad_b,12 D |
Is Hex
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data contains valid HEX string |
| Properties | Default |
| Pass | 3D,FF,CE |
| Fail | DK,KK,12D |
Is Equal To
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is equal to supplied value |
| Properties | search string |
Is Starts With
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data starts with supplied value |
| Properties | Same as ‘Is Equal To’ |
Is Ends With
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data ends with supplied value |
| Properties | Same as ‘Is Equal To’ |
For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions
Confused? Ask question on our ETL Forum