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

Download Free Trial of Advanced ETL Processor
Direct link, no registration required.