Lookup RegEX

Lookup RegEX transformation function

Key Value
Category Transformation Function
Description This function checks input value matches regular expression and if it is returns matching value
Properties Properties are very similar to Lookup Transformation Function

Lookup RegEX transformation function properties

Example

Input field value = 01

key = value
^[0-9]{4} =4Numbers [09]2 = 4 Numbers\ ^[0-9]{2} = 2 Numbers

Since “01” matches “^[0-9]{2}$” regular expression, the result is “2 Numbers”

Video Tutorial

Back to Working with Transformer

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on April 27, 2024 • 1 min read • 113 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License