MappingDataFlow regexExtract - how to use string from another column?

Question

I have a project where I need to apply a regular expression, stored in a table, to all results in another table. I have joined the regex strings to the other table and I have tried to use the regex string column from the joined table in the regexExtract function but it doesn't return a result. Should this be possible?

here is how the function was used:
regexExtract(dataColumn, regexStringColumn)

I tested the regex string directly in the function and it works but when using a value from another column for the regex string it doesn't work. The joined value is visible so the join worked.

Does anyone know if this is possible?

Answer 1

The process actually works as expected, mistake on my part.

Answer 2

Check the escaping characters for differences in what you have in actual regex vs what is stored.