SubString from a String (Names)

  • 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

     

  • thanks all I got it

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply