Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 29, 2017 at 03:10 PM

    Not tested but this might work

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

    Field1 = Jones, Jim LCSW

    Field2 = Jones, Jim

    Ian

    Add comment
    10|10000 characters needed characters exceeded