$ awk '{print $1 " " $5}' < foo | sort -k 2 | [reply] [d/l] |
Please use code tags around your lines. See How do I post a question effectively? for a few more tips.
Next, what have you already tried? Please post your code so we can help. If you're having trouble getting started, have you looked at split and perldata? And when you say "make a table", what kind of table do you want, exactly?
use strict; use warnings; omitted for brevity.
| [reply] [d/l] |
If the data is fairly large (in another post you mention a million lines), dump the data into a database, index the fields you need to sort by and use SQL to sort the data. Using a database will probably also solve the major part of your other tasks with this data.
CountZero A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James My blog: Imperial Deltronics
| [reply] |
Given that your data is quite irregular (some fields are empty on some records), split is probably not the best for this task. The substr or unpack functions are probably better candidates to easily extract data from fixed-length fields/records.
| [reply] |