Extracting Data

[franknove]

I have a file which can contain one name such as John Smith or two names such as John Smith & Betty Brown.

When there are two names they are separated by an "&".

I would like to extract name 1 into two fields Contact1Name and Contact1Surname, and if a second name exists extract it into Contact2Name and Contact2Surname.

Any assistance would be appreciated.

[Lee Smith]

These will work for the example given. However, there can't be any middle names or initials in the contacts names.

LeftWords ( FieldToBeParsed ; 1 )

MiddleWords ( FieldToBeParsed ; 2 ; 1 )

MiddleWords ( FieldToBeParsed ; 3 ; 1 )

MiddleWords ( FieldToBeParsed ; 4 ; 1 )

Lee

[franknove]

Thank you Lee, it worked