Breaking Down a field

From: Box 666 (box666_at_mystical.demon.co.uk)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 12:17:42 GMT

I have a field that is populated as follows

Gillard, Robert J : Retail

The surname always has a comma after it and whilst there is not always an
initial after the 1st name there is always a space and a colon after it. I
need to be able to extract both the surname and 1st name to use in an
unbound text box.

Is it possible to extract this information from the above field, if so ,
how

with thanks

Bob

Relevant Pages

  • Extracting a surname
    ... How do I extract a surname from a name field in which the name is in ... the form: <surname, given names>. ... that I can perform a Leftextraction up to the comma. ... Charlie Hoffpauir ...
    (comp.databases.ms-access)
  • Combine names seperated by comma
    ... I have a database imported into excel, column a has surname and Christin ... names seperated by a comma, ie Adams,John want to extract these into another ...
    (microsoft.public.excel.misc)
  • Re: Breaking Down a field
    ... It's not clear to me whether you want surname and 1st name in separate ... To get only what's in front of the colon, ... To get what's between the comma and the colon, ... > Is it possible to extract this information from the above field, if so, ...
    (microsoft.public.access.gettingstarted)
  • Re: String parsing (2 questions)
    ... How can I extract just the ID1, ID2, ... Van Horn Tim ... surname, or do you have to handle cases like married women who have ... can you make a complete list of valid forenames? ...
    (comp.lang.perl.misc)
  • Re: Halve your cake...
    ... There used to be a time when I misread her signature as meaning "Yes, ... That would have needed a comma, ... My wife didn't take my surname (Chilean women aren't legally allowed to, ...
    (alt.usage.english)