Below is the list of String Transformations supported by Advanced ETL Processor
Image | Data Transformation 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 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 a 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 a right part of a string |
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, duplicate 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 the primary key