CODEWITHSUNDEEP
regexazureazure-data-factory
rderik
rderik

Reputation: 510

Azure Data Factory Derived Column RegexReplace

Is there any way to reference any of the other columns on a regexReplace using string interpolation and also Case Insensitivity?

Something like:

regexReplace("Hola Phillip", /${first_name}/gi,'[First Name]')

I would like that the column ends up with the following string: "Hola [First Name]"

Upvotes: 0

Views: 861

Answers (1)

Kiran-MSFT
Kiran-MSFT

Reputation: 234

The second parameter is just a string. You can formulate it using any string expression construct using other columns.

Upvotes: 1

Related Questions