UpperCase Replace(Split_Part())

Community, I need assistance with removing the UNDER SCORES '_' and make the name readable first name letter UpperCase last name UpperCase, while removing the number as well. Hope this makes sense. I am running Presto and using Query Fabric. I there a better way to write this syntax?

Email Address
Full_Metal_Jacket@movie.com
TOP_GUN2@movie.email.com

Needed Outcome
Full Metal Jacket
Top Gun

Partical working Resolution:

,REPLACE(SPLIT_PART(T.EMAIL, '@', 1),'_',' ') Name  

Something like this:

 ,LOWER(REPLACE(UPPER(SPLIT_PART(T.EMAIL, '@', 1)),'_',' '))Name  

https://stackoverflow.com/questions/67236533/uppercase-replacesplit-part April 24, 2021 at 04:37AM