Substring First name from Full name using advance expression

michellelowsl

05-10-2019

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!

Accepted Solutions (1)

Accepted Solutions (1)

michellelowsl

06-10-2019

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

Answers (1)

Answers (1)

Anita_p

MVP

06-10-2019

Hi Michelle,

The index of Substring starts with "0".

Try below expression. This should work.

Substring(@fullName,0,Charindex(@fullName," "))

Thanks,

Anita