Separate data in field (comma delimited)

[pillroller]

I have a field that contains the full name of individuals. I would like to separate the full name which is separated by a comma into two fields, one with the first name and one with a last name. I want to print name tags with just the first name.

I imported the original data base from Excel and was able to separate the field into 2 columns at a later time, but FileMaker did not recognize the file so I could not import the information.

Thanks for the help.

Pillroller

[-Queue-]

Use a Set Field script step or Replace Field Contents on your FirstName field with a calculation of LeftWords( FullName; 1 ) and one on your LastName field of RightWords( FullName; 1 ). Note that if you have titles or suffixes in any records, this will not work and you'll either need to manually change them yourself or use more complicated calculations.

[RalphL]

Welcome to the Forum,

You can do this using the Left, Right, Position and Lenght functions. Assuming that the field Name = Last Name, First Name.

Last_Name = Left ( Name; Position (Name; ","; 1; 1 ) - 1)

First Name = Right (Name, Lengh (Name ) - Position (Name; ","; 1; 1 ) - 1)

You may have to make an adjustment to make it work since I haven't tested this.