Transforming Data

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 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

 

Below is list of Time Validation Functions supported by Advanced ETL Processor

ImageData Validation FunctionDescription
Is Time Checks if the data is a time value
Is Time Between Checks if the data is a time between two values
Is Time Less Than Checks if the data is a time less than value
Is Time More Than Checks if the data is a time more than value
Is Second Checks if data is a number between 0 and 59
Is Minute Checks if data is a number between 0 and 59
Is Hour 24 Checks if data is a number between 0 and 23
Is Hour 12 Checks if data is a number between 0 and 12
Is PM Checks if the data is a PM Date
Is AM Checks if the data is a AM Date

We have 119 guests and one member online