Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!

Substring First name from Full name using advance expression


Level 3

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!

2 Replies


Level 7

Hi Michelle,

The index of Substring starts with "0".

Try below expression. This should work.

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




Level 3

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