Here is a very basic example of using regular expressions in Advanced ETL Processor

Source data
  • 01-02-2015
Desired Result
  • Field1: 01
  • Field1: 02
  • Field1: 2015

This can be easily done using Split ReX Transformation function

SplitRegXExample1

Result of transformation

Split RegX Example 2

 

Direct link, no registration required.
 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies