Skip to Content
0

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

Jun 29, 2017 at 02:23 PM

33

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Ian Waterman Jun 29, 2017 at 03:10 PM
0

Not tested but this might work

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

Field1 = Jones, Jim LCSW

Field2 = Jones, Jim

Ian

Share
10 |10000 characters needed characters left characters exceeded