Loading part of a feild

[#1]

Hi All,

I have a FullName feild where the names are formatted as follows:

Crab, Peter

On load I want to split this feild into two, one called FirstName and the other called SecondName.

Thanks

JB

[#2]

Hi JB,

You can use;

For First Name --> Left(Field1,Index(Field1,',')-1)

For Last Name --> Mid(Field1,Index(Field1,',')+1,Len(Field1)-Index(Field1,','))

Here "Field1" is your "Name Field"

Regards

Rajesh

[biester · Accepted solution]

I would do it this way:

subfield(NAME,',',1) as SecondName, trim(subfield(NAME,',',2)) as FirstName

[#4]

Subfeild worked a treat, thank you!

JB