Saviynt is not replacing the less than & greater than characters (<>) in System username generation

[Ajit]

Hi Team,

We have created a query to replace all the special characters in system username and email generation logic. Saviynt is replacing all special characters but not replacing less than and greater than (<>) and it is taking as lt & gt respectively.

Below is the code we are using to replace the characters:

replace(replace(replace(replace(replace((replace(users.lastname,'@','')),'_',''),'-',''),'"',''),'.',''),'<>','')

Could you please help how we can replace these (<>) characters.

Thanks

[sudeshjaiswal]

Hello @Ajit,

Could you please try use the below function and see if it works for you,

replace(replace(replace(replace(replace((replace(replace(users.lastname,'<',''),'>','')),'@','')),'_',''),'-',''),'"',''),'.','')

Thanks.

[Ajit]

Hi @sudeshjaiswal ,

Thanks for the response, tried but it's not generating the system username, and also tried with below code but still the issue is same

replace(replace(replace(replace(replace(replace((replace(users.lastname,'<','')),'>',''),'-',''),'"',''),'.',''),'@',''),'_','')

[sudeshjaiswal]

Hello @Ajit,

Can you please try using the translate function in the query:
replace(replace(replace(replace(replace(replace((replace(users.lastname,'@','')),'_',''),'-',''),'"',''),'.',''), TRANSLATE(users.lastname, '<>', ''),'')


Also please traced the logs and share the log snippet.

Thanks.

[Ajit]

Hi @sudeshjaiswal ,

Please find the code we tried:

concat(replace(replace(replace(replace(replace((replace(users.lastname,'@','')),'_',''),'-',''),'"',''),'.',''), TRANSLATE(users.lastname, '<>', ''),''), replace(replace(replace(replace((replace((SUBSTRING(users.firstname,1,1)),'@','')),'_',''),'-',''),'"',''),'.',''), '@xyz.com')

Error in the logs:

Please let us know if we are missing anything.

Thanks

[sudeshjaiswal]

Hello @Ajit,

Did you try to use the same in Modifyuserdatajson during import instead of system username generation rule.

Thanks