Names Splitting

• Ghanta Bro

  Ten Centuries

  Points: 1079

  More actions

  September 30, 2005 at 3:39 pm

  #165642

   

  I am sure you guys must have seen a script to resolve this...

  I have file with two columns for names:

   

  Col001          Col002  

  John D.          Philips

  John D           Philips

  John Dev        Philips

  I need output like this:

  Col001              Col002        Col003

  John                 Philips          D.

  John                 Philips           D

  John                Philips            Dev

  I basically need to break names into first, middle and last... I have last in the lastname column, middlename column is to be filled with middlename which is combined in the firstname. Any help is appreciated. Thanks all!

   

• Ghanta Bro

  Ten Centuries

  Points: 1079

  More actions

  September 30, 2005 at 4:20 pm

  #594418

  thanks all I got it...