how to parse out a name? where there's a comma

[Former Member]

HI I have a name column with such data:

Jones, Jim LCSW

I need to compare this against

Jones, Jim

But the practitioners title can be different, some are MD, etc.

I need a formula that will stop after the second space (could be problematic, but that is ok). Some practitioners do not have a title so they would be

Jones, Jim

[Former Member · Accepted solution]

Not tested but this might work

If Field1 startswith(Rtrim(Field2)) then true else false

Field1 = Jones, Jim LCSW

Field2 = Jones, Jim

Ian