Regex in PreProcessor

[HarishG]

Hi,

Can we use regex in PreProcessor to check the one of the column in the User import?

Requirement is to validate if the email following Regular Expression(^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,6}$). If not user should be skipped.

Thanks,

Harish

[rushikeshvartak]

You can try but it does not work 

SELECT *
FROM users
WHERE email NOT REGEXP '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\\.[A-Za-z]{2,6}$';