Hi Experts,
We are seeing username is getting created with spaces, Although the last name have space or any special character it should consider it and eliminate the same and create it. but that is not happing especially with space.( something if last name is like St. Andrews).
Username Generation rules
Rule1
Users
FirstName Initial character: 1
Last Name :Initial character: 7
We were asked to use the advance config in register user rule to get the space removed.
We are trying with multiple combinations as below,but still we have not got to resolving it yet
CASE WHEN (users.username is NOT NULL) then CONCAT(substring(users.firstname,1,1), substring(REPLACE(users.lastname,' ',''),1,7)) ELSE CONCAT(substring(users.firstname,1,1), substring(REPLACE(users.lastname,' ',''),1,5),FLOOR(RAND()*100)) END ### CASE WHEN (users.username is NULL) then CONCAT(substring(users.firstname,1,1), substring(REPLACE(users.lastname,' ',''),1,5),FLOOR(RAND()*100)) ELSE CONCAT(substring(users.firstname,1,1), substring(REPLACE(users.lastname,' ',''),1,5),FLOOR(RAND()*100)) END
Thanks
Shyam
