Parsing (I think!)

[Baylah]

Hi All,

I'm pretty sure this can be done, but this is new to me.

When I get my raw data from an Excel spread sheet I have 2 fields for name:

First Name

Last Name

Is there a way in FMP that I can combine the two fields into 1 so the result equals:

Field Name = "Full_Name"

result = Last_Name, First_Name

Thanks for any help!

Steve

[RalphL]

That is the way it should be. Add a new calculation text field Full_Name = Last_Nam,e & ", " & First_Name.

[Baylah]

Thank you!

That was easy and I should have thought of that myself!

I need to learn how to think these things through better.

All part of the continuous learning curve with this amazing software.

Steve