Easy to use, fast and powerful ETL tools, Our prices start from only 100 USD per licence.

Work with: Text, XML, Excel, Access, DBF, Foxpro, Paradox, ODBC, BDE, OLE DB, MS Sql Server, Oracle, MySql, MariaDB, PostgreSQL, Greenplum, Firebird, Interbase, SQLite, POP3, IMAP4, SMTP, HL7, HTTP, File System, FTP, SSL, Unicode, RSS, Windows Event Log, Google Spreadsheets, SalesForce, BrightPearl and QlikView.

Built-in scheduler, business rules designer, package designer, report designer, data browser. Powerful data transformation language, regular expressions and more...

Transformation Functions

String Transformation

Below is list of String Transformations supported by Advanced ETL Processor

Image Data Validation Function Description
Upper Case Converts all characters of a string to Upper Case My String => MYSTRING
Lower Case Converts all characters of a string to Lower Case My String => my string
Proper Case Converts first character of all words within a string to Upper Case and the rest to the lower case my strinG => My String
First Up Converts first character a string to Upper Case and the rest to the lower case my strinG => My string
Delete Spaces Makes sure that there is only one space between words My string => My string
Trim Removes Leading and Trailing Spaces from a string
Left Trim Removes Leading Spaces from a string
Right Trim Removes Trailing Spaces from a string
Sub String Returns part of a string.
Replace Replaces a one or more characters from the data with zero or more new characters.
Ensure Prefix Check string for prefix and if it is missing adds it
Ensure Suffix Check string for suffix and if it is missing adds it
Ensure No Prefix Check string for prefix and if it is present removes it
Ensure No Suffix Check string for suffix and if it is present removes it
Left Pad Returns the string left-padded to the length with spaces or specified character.
Right Pad Returns the string right-padded to the length with spaces or specified character.
Escape String Replaces special characters such as TAB, CR, LF,NULL,BEL,BS,ESC,HT,FF,VT with there C-Style escape equivalents.
UnEscape String Opposite to Escape String, Replaces C-Style escape characters with special characters such as TAB, CR, LF,NULL,BEL,BS,ESC,HT,FF,VT.
Delete Deletes part of a string.
Left Returns left part of a string.
Right Returns right part of a string
Left Delete Deletes left part of a string
Right Delete Deletes right part of a string

Number Transformations

Below is list of Number Transformations supported by Advanced ETL Processor

Image Data Validation Function Description
Round Rounding is the process of reducing the number of significant digits in a number. The result of rounding is a "shorter" number having fewer non-zero digits yet similar in magnitude. The result is less precise but easier to use.For example: 73 rounded to the nearest ten is 70, because 73 is closer to 70 than to 80.
Abs Returns absolute value of a number. Absolute value is always positive. For example -2 will give 2
Sign Returns Sign of numeric value -1 for negative values, 1 for positive values and 0 for 0

More Articles...

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