Calc for two first names?

[lpm]

I have a field (FullName) that reverses the order of a person’s name in another field (ReverseName).

Example: Smith, Sara becomes Sara Smith

This is what the calculation looks like now for the FullName field:

Right (ReverseName; Length (ReverseName) - Position (ReverseName; " "; Length (ReverseName);-1))

& " " &

Left (ReverseName; Position (ReverseName; " " ;1;1) - 2)

This works OK, but some people have two first names (Sara Gray Smith).

How can I write a calc for a Name field with two first names?

Example: Smith, Sara Gray should become Sara Gray Smith

TIA lpm

[sbg2]

If your data is entered consistently use the comma to get your position. Everything to left of the comma is the last name & everything to the right is the first. This will be helpful if/when you get last names like Van Buren etc.