Need more information on email generation and system username generation rules

[Kanchukuri]

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?

[rushikeshvartak]

Use database functions https://docs.saviyntcloud.com/bundle/EIC-Admin-v2022x/page/Content/Chapter02-Identity-Repository/Dat...

[draut]

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,

[Sitarasmi]

Hi Team,

We are using basic configuration rules to generate systemusername & email . Could you please guide how to achieve 

Thanks,

Sitarasmi

[draut]

Please try with Advance Config.