Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/17/2024 09:46 PM
Hi,
I wrote the following logic to remove accented characters from the email generation rule. But after running this query it drops the accented character and forms email without including them.
Query: -
FN_EIC_MAPPING((CASE
WHEN users.preferedfirstname IS NOT NULL AND trim(users.preferedfirstname <> ' ') THEN REPLACE(CONCAT(users.preferedfirstname,'_',users.lastname,'@xyz.com'), ' ', '_')
ELSE
REPLACE(CONCAT(users.firstname,'_',users.lastname,'@xyz.com'), ' ', '_')
END),null) #
Output:
This query just drops the accented character.
Please let me know how I can normalize it?
06/18/2024 08:20 PM
what is characters specified in REPLACE_MAPPING dataset for replacement