|
Below is list of String Transformations supported by Advanced ETL Processor  | 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 |
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
|
