Validating Numbers
To change Validation Function properties double click on it
Is Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a Number |
| Properties | Default |
| Pass | 12,123.6,1 |
| Fail | adc1, ad b,11 112.D |
Is Integer
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is an Integer |
| Properties | Default |
| Pass | 12,123,1 |
| Fail | 12.5,ad b,11 112.8 |
Is Positive
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is an Positive Number |
| Properties | Default |
Is Negative
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is an Negative Number |
| Properties | Default |
Is Number Between
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a number between two values |
| Properties |
Is Number Less Than
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a number less than value |
| Properties |
Is Number More Than
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Checks if the data is a number more than value |
| Properties |
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