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

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.

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.