On Sunday 02 February 2003 06:03 pm, David E. Fox wrote: > > of lines long), so she consulted with our MS guru who didn't have a > > solution. Didn't take long for me and my SCO box to provide her with > > Her M/S "guru" didn't know about Excel's Data Sort feature? She could > have had that report in excel, sort on the desired column and go. It's > really simple. Of course, with Unix you could have kept the file in > ascii form, run the sort and be done before the M/S person got Excel > loaded up :).
hehe nope! I'll give the data sort feature a gander when I'm in the office tomorrow. Also, 'uniq -c' provided what she really needed- the number of occurances of each account number, and some account numbers were repeated hundreds of times! I'm sure a person could write a macro for excel to do the counting but it's so much cooler to whip out ye ole unix toolbelt to get the job done.
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
