The process actually works as expected, mistake on my part.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
The process actually works as expected, mistake on my part.
Check the escaping characters for differences in what you have in actual regex vs what is stored.