Validate email in ADF

Question

Validate email in ADF

Ashok A 20

How to validate email in ADF - mapping data flow. I am using below regex in my conditional split transformation in ADF, but getting error. Same regex is working fine in my local python program. Please help.

regexMatch(email,'^([a-zA-Z0-9._%-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,})$')

error1.JPG

Vahid Ghafarpour 23,385 Reputation points Volunteer Moderator

2023-10-01T04:42:40.2133333+00:00

Did you try regexMatch(email,^([a-zA-Z0-9._%-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,})$)

Accepted answer

0 additional answers

Your answer

Vahid Ghafarpour 23,385 Reputation points Volunteer Moderator

2023-10-01T04:42:40.2133333+00:00

Did you try regexMatch(email,^([a-zA-Z0-9._%-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,})$)

Answer 1

Vahid Ghafarpour 23,385 Volunteer Moderator

I think you need to take care of escape characters and replace ' with `

Use the back quote to match a string without escaping.

https://learn.microsoft.com/en-us/azure/data-factory/data-flow-expressions-usage#regexMatch

Ashok A 20 Reputation points

2023-10-01T13:40:17.4266667+00:00

Thank you, Vahid Ghafarpour, it works with back quote.

Share via

Validate email in ADF

0 additional answers

Your answer