select only first names

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If a field contains "John Doe and Jane Tarzan"

How do you extract "John and Jane"

The field is different lengths depending on the size of the names. I need to
write a letter that would say:

Dear John and Jane, ...

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200605/1
.

Relevant Pages

  • Re: Using FIND function to locate space between first and last name
    ... John Doe, MD ... I am trying to extract last names out of a list of doctors formated as ... Or is it possible to count up to the second upper case letter in the ... string which would give me the start of the last name? ...
    (microsoft.public.excel.worksheet.functions)
  • E-mail Signature Xtraction
    ... knowing that im a noob at this... ... way to extract a person's personal signature at the end of an email. ... John Doe ...
    (microsoft.public.scripting.vbscript)
  • mail addresses
    ... I can extract the sender by using. ... John Doe ... TIA, ...
    (comp.lang.python)