how to sort data in txt file

[soclose]

Hi All,

I want to sort data in a txt file like Notepad. But my data is like table format. i mean there are rows and columns data. I want to sort one column, A, in descending. after sorting it, all rows are sorted based on column A sorted order and saving these data to txt file. could we sort the data like this? if so, pls share me the way.

example,

Before Sorting

X Y Date Time Altitude Speed
N 90.1243 E 29.4532 09/30/2007 10:24:12AM 00:00:30 34 ft 0.8 mph
N 90.3456 E 29.3456 09/30/2007 10:24:12PM 00:10:30 10 ft 0.9 mph
N 90.2143 E 29.1254 09/30/2007 09:24:12AM 00:05:30 20 ft 0.8 mph
N 90.1043 E 29.3421 09/30/2007 06:24:12PM 00:25:30 34 ft 0.8 mph
N 90.1673 E 29.4562 09/30/2007 10:00:12AM 01:15:30 34 ft 0.6 mph


After Sorting(Main Sorting Column - Time)

X Y Date Time Altitude Speed
N 90.1673 E 29.4562 09/30/2007 10:00:12AM 01:15:30 34 ft 0.6 mph
N 90.1043 E 29.3421 09/30/2007 06:24:12PM 00:25:30 34 ft 0.8 mph
N 90.3456 E 29.3456 09/30/2007 10:24:12PM 00:10:30 10 ft 0.9 mph
N 90.2143 E 29.1254 09/30/2007 09:24:12AM 00:05:30 20 ft 0.8 mph
N 90.1243 E 29.4532 09/30/2007 10:24:12AM 00:00:30 34 ft 0.8 mph