Hello All,
How to separate/ split name and surname in useremail and present it with uppercase letters from name.surname@company.com to Name Surname.
Thanks, it's my start with appsheet so please be understanding with that:)
Solved! Go to Solution.
You could get the name and surname from the email string if the pattern of emails is same as you showed.
However , putting that in title case is not very easily possible with AppSheet. AppSheet converts entire string to upper case or lower case with UPPER() and LOWER() functions.
You could get name and surname separated with an expression something like
SUBSTITUTE(TOP(SPLIT(SUBSTITUTE(SUBSTITUTE("name.surname@company.com",".", ","),"@",","),","),2),",","")
You could get the name and surname from the email string if the pattern of emails is same as you showed.
However , putting that in title case is not very easily possible with AppSheet. AppSheet converts entire string to upper case or lower case with UPPER() and LOWER() functions.
You could get name and surname separated with an expression something like
SUBSTITUTE(TOP(SPLIT(SUBSTITUTE(SUBSTITUTE("name.surname@company.com",".", ","),"@",","),","),2),",","")
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |