Level 1
Level 2
Sign in to Community
Learn more
Sign in to view all badges
Expand my Community achievements bar.
This conversation has been locked due to inactivity. Please create a new post.
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)))
Views
Likes
Replies