and more in a single search tool across platforms. Read the announcement here. |
03/26/2024 02:32 AM
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
03/26/2024 09:21 PM
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}$';