Pulling First Name from a Name field with varying formats

[June7]

Try this addition to the SELECT CASE structure:


Case Else
resL = strName

Then the final concatenation of SplitNamesAll should just return the original full string.

[cliff.clayman]

That fails on an example like this:

Baker, Jr, James

[June7]

What do you by 'fails' - error message, wrong results, nothing happens?

I expect it returns wrong result because as I already pointed out in post 14 - how is the code supposed to know that Jr is not first name?

Perhaps the 'powers that be' need to read this thread.

[cliff.clayman]

Sorry, I should have been more specific. The query results in a blank value whereas before without the additional code, it returned James Baker, Jr

[June7]

The Case Else needs to be placed just above the End Select line.

[cliff.clayman]

I still get no value.

[June7]

It works for me. Post your edited code for analysis.

Ooops, sorry. Try:

281 Case Else
282 SplitNamesAll = strName
290 End Select

[cliff.clayman]

That seems to work now! Thanks for all the assistance!!!