acquiring first name fron full name. space delimited

[#1]

Hi,

I am trying to get only the first name from the full name.

and full name is divided by space.

I am trying to use it expression.

please help

Thank you!

David

[swuehl]

Try subfield function

=Subfield(FullName,' ',1)

[saimahasan · Accepted solution]

Try

=SubField(field_name,' ');

If it doesn't solves your problem then you please post sample data

[saimahasan]

or you can refer this link:

Re: how to split fullname into first name and last name