Search Results

Thank you pilnet101. That works perfectly!

Used awk and sed to get the file to the format shown in the previous post, but I am stuck at this point.

The following is a sample of the data I am working with:

ID#___Hour

ID=10008 19
ID=10008 20
ID=10014 19
ID=10014 20
ID=21047 20

Need to get the following output:
...

Great. Thanks again

Similar to the original file, but with a single line for occurrence
(Example with the first 4 lines):
2:15 3001 146.25
2:15 3002 27.5

The first value is time, the second is a group id and the...

Hello,

Below is a portion of a file I am working on:
2:15 3001 120
2:15 3001 26.25
2:15 3002 12.5
2:15 3002 15
9:45 3001 45
9:45 3001 45
9:45 3002 105
9:45 3005 180
9:45 3005 123.75
9:45...