Hi all,
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!
Hi Michelle,
The index of Substring starts with "0".
Try below expression. This should work.
Substring(@fullName,0,Charindex(@fullName," "))
Thanks,
Anita
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?
Thanks again!
Case(When(@fullName LIKE ' ', Substring(@fullName,0,Charindex(@fullName, " ")), Else(@fullName)))