Loading ...
Sorry, an error occurred while loading the content.
 

Re: [Clip] Isolating LAST NAME from a line of text

Expand Messages
  • Robin Chapple
    Many thanks for all of the suggestions. This one provided the majority of required results. As mentioned by some of you some last names have unusual
    Message 1 of 9 , Jul 16, 2010
      Many thanks for all of the suggestions. This one provided the
      majority of required results. As mentioned by some of you some last
      names have unusual characters. These were so minimal that I was able
      to change them manually.

      I appreciate the help.

      Robin Chapple


      At 16/07/2010 11:37 PM, Alex Plantema wrote:
      >Op vrijdag 16 juli 2010 14:31 schreef Robin Chapple:
      >
      > > I have a list of names presented in the format:
      > >
      > > John SMITH (1906-1930)
      > >
      > > Is is possible to remove the other text and retain the word in
      > > uppercase?
      >
      >This seems to work:
      >^!Replace "^.* ([A-Z]{2}[A-Z -]*) \(.*$" >> "$1" WRSA
      >
      >It starts with the first occurrence of two uppercase letters and
      >ends at the space preceding the left parenthese.
      >Last names containing spaces and hyphens after the second letter are
      >allowed as well.
      >You might add other characters.
      >
      >Alex.
      >
      >
      >
      >------------------------------------
      >
      >Fookes Software: http://www.fookes.com/
      >NoteTab website: http://www.notetab.com/
      >NoteTab Discussion Lists: http://www.notetab.com/groups.php
      >
      >***
      >Yahoo! Groups Links
      >
      >
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.