Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

How to remove accented characters for email generation logic?

anujapawar
New Contributor
New Contributor

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:

anujapawar_0-1718685909103.png

This query just drops the accented character.

Please let me know how I can normalize it?

1 REPLY 1

rushikeshvartak
All-Star
All-Star

what is characters specified in REPLACE_MAPPING dataset for replacement 


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.