#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2010
    Posts
    13
    Rep Power
    0

    Remove Middle Initial


    I have a csv file containing company names and contact names. Middle initials always occur as '\,* [A-Z]\,". I need to remove all occurrences of middle initials without removing trailing initials from company names (e.g., "B & B," "M & M").
    How?
  2. #2
  3. Sarcky
    Devshed Supreme Being (6500+ posts)

    Join Date
    Oct 2006
    Location
    Pennsylvania, USA
    Posts
    10,908
    Rep Power
    6351
    If middle initials are always a single letter bound by commas, you're done. You've already given a regular expression that matches. What else is wrong?

    -Dan
    HEY! YOU! Read the New User Guide and Forum Rules

    "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin

    "The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002

    Think we're being rude? Maybe you asked a bad question or you're a Help Vampire. Trying to argue intelligently? Please read this.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2010
    Posts
    13
    Rep Power
    0
    Middle initials are always preceded by a first name and a space.

IMN logo majestic logo threadwatch logo seochat tools logo