Sign in to Community
Sign in to view all badges
Expand my Community achievements bar.
I'm trying to extract first name from full name using Substring(@fullName,1,Charindex(" ",@fullName))
However, it does not work. My Charindex returns 0. Can someone help me with this?
Thanks in advance!
The index of Substring starts with "0".
Try below expression. This should work.
Thanks so much Anita.
I'm trying to substring only when there's a space. However, I got a case function error for the expression below. Can you help?
Case(When(@fullName LIKE ' ', Substring(@fullName,0,Charindex(@fullName, " ")), Else(@fullName)))