Excluding first word in a field.

[product26]

I need to exclude the first word in a field. Our database does not have individual fields for first and last name, we simply have "{customer.custname}". (this is because we service businesses as well as individuals, but we need to be able to search for them from the same field)

I have "{customer.custname}[1]" to get the first initial. But how do I skip the first name, and display everything after the first word?

 

[lbass]

Use a formula like this:

stringvar array x := split({customer.custname}," ");
if ubound(x) > 1 then
x[2] else
{customer.custname}

-LB

 

[product26]

PERFECT! Thank you!