How to extract certain columns from a big Notepad text file?

Posted by user560464 on Stack Overflow See other posts from Stack Overflow or by user560464
Published on 2011-01-02T17:04:54Z Indexed on 2011/01/02 21:53 UTC
Read the original article Hit count: 118

Filed under:

I have a big text file and the data in it are in 5 columns, but I need just the first and the last column of that.

It will take many days and probably with mistake if I want to enter the data of this two column one-by-one from here to another file. Is there a fast way to do this? For example:

     1   1.0000000000000000         0.0000000000 S {0}
     2   1.5000000000000000         0.3010299957 C {2}
     3   1.7500000000000000         0.6020599913 S {0,2}
     4   2.0000000000000000         0.7781512504 C {3}
     5   2.3333333333333333         1.0791812460 C {3,2}
     6   2.5000000000000000         1.3802112417 S {3,0,2}
     7   2.5277777777777778         1.5563025008 S {0,3}
     8   2.5833333333333333         1.6812412374 S {3,0,0,2}
     9   2.8000000000000000         1.7781512504 C {5,2}
    10   3.0000000000000000         2.0791812460 C {5,0,2}

I need the first column (numbering) and the last inside { }.

© Stack Overflow or respective owner

Related posts about notepad