Validating Strings

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

Image Data Validation Function Description
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

Questions?

Learn MoreDownloadBuy Now

Testimonials

Support team is quick and very often they reply to forum posts within minutes.

Mark Jonson,
EDS

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Databases we work with