Formulas to breakup full name field into first and last?

[pokerace]

C10
Interbase

One of my data sources is an excel spreadsheet where the name field is "last, first". I want to create one formula in Crystal to pull just the last name and another formula to pull just the first name. What is the best way to do that?

Thanks.

 

[Kendel]

Check this out faq767-3164

 

[Kendel]

Or just using the split function as synapsevampire uses in other post


For the first:
split({table.field},",")[1]

and for the second:
split({table.field},",")[2]

 

[synapsevampire]

Ammend the second formula slightly to remove the space:

and for the second:
trim(split({table.field},",")[2])

-k