Transformation functions in Advanced ETL Processor allow you to clean, convert, calculate, format, and manipulate data as it moves through an ETL transformation. Use built-in functions to work with strings, numbers, dates and times, file names, lookups, XML, HTML, JSON, regular expressions, and other common data transformation requirements.
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum