Sponsored Content
Top Forums Shell Programming and Scripting Aggregate data within the file Post 302961191 by Don Cragun on Wednesday 25th of November 2015 04:27:19 AM
Old 11-25-2015
Note that for any of the solutions suggested with sorted output, the output won't be sorted by the ord field unless all ord values have the same number of digits; won't be sorted by line within ord unless all line values are single digits; and won't be sorted by date within ord and line unless all dates are for the same year, all months are presented as two digits (which we can't tell from the sample given), and all days are presented as two digits (which we can't tell from the sample given). But, as long as the hour field is always represented with two digits surrounded by double quotes, the hour value fields for any given ord, line, and date triple will be in sorted order.

With the awk suggestion I provided in post #7, the output order is random (but the count will be aggregated into a single output line for each input ord, line, date, and hour quadruple whether or not the input is sorted).

If you do need output that is sorted with ord value as the primary key, line value as the secondary key, date as the tertiary key, and hour as the quaternary key; we need more details about the formats of the first three fields.
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

aggregate ethernet ports under Solaris

I have been looking for info on how to aggregate 2 ore 3 NIC's into into one big pipe. Any advice would be appreciated. -Chuck (4 Replies)
Discussion started by: 98_1LE
4 Replies

2. UNIX for Dummies Questions & Answers

Aggregate values in a file & compare with sql output

Hi, I have a file containing the following data: junk123junk723itemcode001qty01price10total10junkjunk junk123junk723itemcode002qty02price10total20junkjunk .. .. .. could be 5000+ lines I have an algo and need a code to implement this: 1. Linecount = wc -l (should give 5000) 2. For i... (1 Reply)
Discussion started by: shiroh_1982
1 Replies

3. UNIX Desktop Questions & Answers

Aggregate title to an archive.log

Hello how are you, i have a question i have a file ale.log and i want to agregate a title and later a space when the text is over and put another title (when the text is over) how can i do this? thank you Example Last ------>(Title) i want to agregate pupu pupu pupu pupu... (1 Reply)
Discussion started by: enkei17
1 Replies

4. UNIX for Advanced & Expert Users

AWK aggregate records

Hy all, I have a problem...can some one help me... I have a file of records sort: 30|239|ORD|447702936929 |blackberry.net |20080728|141304|00000900|2|0000000000000536|28181|0000000006|0000000001|10|1 30|239|ORD|447702936929 |blackberry.net ... (4 Replies)
Discussion started by: anaconga
4 Replies

5. IP Networking

Aggregate two internet connections

Hi I have a question related to load balancing.I have two separate internet connections with 2Mbps speed and i would like to aggregate this two connections intro one connection with 4Mbps.Is it possible to do that, to put a Linux or Unix machine as a gateway?I read some stuff to split the... (3 Replies)
Discussion started by: tafil
3 Replies

6. Shell Programming and Scripting

Awk Multiple Files & Aggregate

file 1: 70|236|PPS|0501011818|mms|20090706|001452|00000024|2|0000000000000000|00000|0000000000|0000000000|40948000|1 70|236|PPS|0501020076|mms|20090705|204408|00000019|2|0000000000000000|00000|0000000000|0000000000|40947930|1... (3 Replies)
Discussion started by: magedfawzy
3 Replies

7. Shell Programming and Scripting

simple aggregate task

Hi experts, I need an help on the task below. INPUT: values separated by the tab,first row is the header 20110609 AS A 300.5000 20110609 AS R 200.5000 20110609 BR A 111.5000 20110609 BR R 222.5000 20110610 AS A 100.5500 20110610 AS ... (2 Replies)
Discussion started by: hernand
2 Replies

8. Shell Programming and Scripting

Aggregate variables bdfore ssh into remote host

Hi all, I have a problem where i'm trying to identify on which remote hosts the apps are running, ssh into it and restart them. In case more than 1 apps is running on same remote host, i want to be able to group it and ssh only once. E.g: app1 = 1.1.1.1 app2 = 1.1.1.2 app3 =... (4 Replies)
Discussion started by: varu0612
4 Replies

9. Solaris

IPMP over aggregate in Solaris 11

hi all, i start with solaris 11 and i am disapointed by the change on ip managing. i want to set a ipmp over tow aggregate but i dont find any doc and i am lost with the new commande switch1 net0 aggregate1 | net1 aggregate1 |-----| |... (1 Reply)
Discussion started by: sylvain
1 Replies
ROLLDICE(6)							   Games Manual 						       ROLLDICE(6)

NAME
rolldice - rolls virtual dice SYNOPSIS
rolldice [ options ] dice_string dice_string ... DESCRIPTION
rolldice rolls virtual dice. The dice strings passed on the command line contain information on the dice to roll in a format comparable to the format used in fantasy role playing games. OPTIONS
-h,--help returns the usage of diceroll -v,--version returns the version of diceroll -r,--random uses /dev/random for random number generating -u,--urandom uses /dev/urandom for random number generating (default) -s,--separate prints out the result of each individual die separately, as well as the operations and totals DICE STRING FORMAT
The dice string uses the following format: {#x}{#}d[#|%]{*#}{+/-#}{s#} The dice string doesn't have to be in the format that I outlined above, but this is the nicest order for me. It will try to parse any dif- ferent string containing the same sections in the best way it can, and will throw out anything that isn't one of the sections below. {#}d[#|%] This is the only required part of the string, and now really isn't even required, as it defaults to 1d6 if not found. The first number is the number of dice to roll, and the second number is the number of sides the dice have. The numbers rolled on each die are then added up and given as the result. Hence 3d6 means "roll three six-sided dice, add them together and return the result". If the first number is left out, then the number of dice defaults to 1. If the second number is not a number, but a percentage sign, then the number of sides becomes 100 (for a percentage roll). {#x} This number tells how many times to roll. For example, if you want to roll 3 6-sided dice 6 times, you would say 6x3d6. This would return six numbers, corresponding to the six different rolls. {*#} This number tells how many times to multiply the result of each roll. 3d6*100 would return a number in the range of 300-1800, since 3-18 is the range resulting from 3d6, which is then multipled by 100. {+/-#} This number is the modifier to be added or subtracted, depending on the sign, from each roll. 1d4+1 would result in a range from 2-5 (1-4 for the die, plus 1). This step is handled *after* the multiplication modifier. {s#} This number tells the program to drop the # lowest dice rolls. This step is handled *before* the multiplication modifier. in the order show above. For an extreme example, "3x4d6*5+1s2" would roll four six-sided dice, drop the lowest two, multiply the result by 5, add 1 to that, and repeat the process two more times, for a total of three results. DIAGNOSTICS
The following error messages may appear on STDERR: Failure in getting dice attributes Either memory could not be allocated while parsing the string passed to the rolldice program or an invalid dice string was entered. Failure in rolling dice Memory could not be allocated while actually rolling the dice. Unknown option Take a wild guess ;) BUGS
I haven't noticed any yet... rolldice is a quick hack to provide a virtual dice roller for FRPGs that I play. Any improvements are greatly welcome, as I am not the most experienced C coder... AUTHOR
Stevie Strickland <sstrickl@cc.gatech.edu> VERSION
1.10 - 25 Nov 2001 Linux 25 Nov 2001 ROLLDICE(6)
All times are GMT -4. The time now is 03:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy