Separate name and surname in useremail

[Jackson5524]

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:)

[Suvrutt_Gurjar · Accepted 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),",","")

SUBSTITUTE() - AppSheet Help

TOP() - AppSheet Help