and more in a single search tool across platforms. Read the announcement here. |
02/25/2024 10:24 PM
Could you please provide the resolution for below two queries.
1) How to exclude special character in the System Username Generation Rule?
2) How to exclude space in the email generation rule?
02/25/2024 10:25 PM
Use database functions https://docs.saviyntcloud.com/bundle/EIC-Admin-v2022x/page/Content/Chapter02-Identity-Repository/Dat...
02/26/2024 09:47 AM - edited 02/26/2024 09:49 AM
lower(concat((replace(replace(replace(replace(users.firstname,' ',''),'''',''),'.',''),',','')),'.',(replace(replace(replace(replace(users.lastname,' ',''),'''',''),'.',''),',','')),'@domain.com'))
#lower(concat((replace(replace(replace(replace(users.firstname,' ',''),'''',''),'.',''),',','')),'.',(replace(replace(replace(replace(users.lastname,' ',''),'''',''),'.',''),',','')),'1@domain.com'))
#lower(concat((replace(replace(replace(replace(users.firstname,' ',''),'''',''),'.',''),',','')),'.',(replace(replace(replace(replace(users.lastname,' ',''),'''',''),'.',''),',','')),'2@domain.com'))
#lower(concat((replace(replace(replace(replace(users.firstname,' ',''),'''',''),'.',''),',','')),'.',(replace(replace(replace(replace(users.lastname,' ',''),'''',''),'.',''),',','')),'3@domain.com'))
#lower(concat((replace(replace(replace(replace(users.firstname,' ',''),'''',''),'.',''),',','')),'.',(replace(replace(replace(replace(users.lastname,' ',''),'''',''),'.',''),',','')),'4@domain.com'))
Try this it will remove the special characters ( Space, apostrophe, Dot, and comma) from firstname and lastname in the email generation rule
#For special character apostrophes, need to use '' to escape it properly in the replace function.
Regards,
02/27/2024 11:24 PM
Hi Team,
We are using basic configuration rules to generate systemusername & email . Could you please guide how to achieve
Thanks,
Sitarasmi
02/28/2024 07:09 AM
Please try with Advance Config.