I have a text file imported from Excel 2003 in the following basic format.
43038 12500 s.ramesh labour 43038 13000 m.ramesh doctor
I have to arrange this file in such a format that column 1 should be from 1-5.
The problem is that columns 2,3 and 4 are not arranged in the particular order.
I want this file in such an order that
- column 2 of the entire file should be in the 15-19 place
- column 3 should be in 49-65
- column 4 should be in 75-95th position
The file has 100000 rows and 4 columns plz.
I am looking for advice on whether sort, vi, or any other editor or shell would be helpful, because I have to do this for about 100 files daily.