NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

Validating Strings

Below is a list of String Validation Functions supported by Advanced ETL Processor

ImageData Validation FunctionDescription
Is Null Checks if the data is equal to null.
Is Empty String Checks if the data is Empty String. (Length of the string is zero).
Is Alpha Checks if the data contains only Alpha characters.
Is Alpha Numeric Checks if the data contains only Alpha Numeric characters.
Is Hex Checks if the data contains valid HEX string
Is Equal To Checks if the data is equal to supplied value
Is Starts With Checks if the data starts with supplied value
Is Ends With Checks if the data ends with supplied value
Contains Checks if the data contains supplied value
In List Checks if the data exists within supplied list values

Advanced ETL Processor is designed to automate extracting data from ANY database, transform, validate it and load into ANY database . Typical usage of it would be extract data from Excel File,Validate Date Formats, Sort data, deduplicate it and load it into Oracle database, run stored procedure or Sql script, once loading is completed. Unlike Oracle SQL loader, BCP,  DTS or SSIS Advanced ETL Processor can also add new and update old records based on primary key

Visit Support Forum Learn More Download Buy It
"Because of our relationship with DBSL, We are able to provide more complete solutions for our customers. As one of our key technology partners, DBSL is always willing to go that extra mile: adding new functionality, assisting us with support issues ... and this has been an important part of our success."

Bill Dill,
Deployment Manager

Our customers






Australian Rugby Union
Databases we work with