02-13-2007
Adding field of flatfile by an index.
Hey guys, I was given a task that involved parcing a large file that looked somthing like this...
A1-0999999,SMITH,.25
A1-0999999,JOHN,.75
A1-0999999,HELMET,.1.25
A1-0999999,HOOP,.10.25
D1-1212121,SMITH,4.00
D1-1212121,TH,9.00
D1-1212121,MITCH,10.20
D1-1212121,RETAL,3.00
A1-9909555,,3.00
E1-099999,,7.00
What the task at hand is, is to Produce a file that looked like this...
A1-0999999,,12.50
D1-1212121,,26.20
A1-9909555,,3.00
E1-099999,,7.00
I am basically condensing by the 1st value and adding up the 3rd field based on a common 1st field. I figured a way to do this using grep, but it was taking way too long. I would like to write an awk script that will add up field three until the 1st field changes, then print the 1st feild and the sum of all the 3rd feilds.
Any help would be greatly appreciated!
Any help would
10 More Discussions You Might Find Interesting
1. Filesystems, Disks and Memory
why do inode indices starts from 1 unlike array indexes which starts from 0
its a question from "the design of unix operating system" of maurice j bach
id be glad if i get to know the answer quickly
:) (0 Replies)
Discussion started by: sairamdevotee
0 Replies
2. UNIX for Dummies Questions & Answers
brothers why inode index starts from 1 unlike array inex which starts from 0
its a question from the design of unix operating system of maurice j.bach
i need to know the answer urgently...someone help please (1 Reply)
Discussion started by: sairamdevotee
1 Replies
3. Shell Programming and Scripting
Hi All,
I have a file (FileNames.txt) which contains the following data in it.
$ cat FileNames.txt
MYFILE17XXX208Sep191307.csv
MYFILE19XXX208Sep192124.csv
MYFILE20XXX208Sep192418.csv
MYFILE22XXX208Sep193234.csv
MYFILE21XXX208Sep193018.csv
MYFILE24XXX208Sep194053.csv... (5 Replies)
Discussion started by: krish_indus
5 Replies
4. Shell Programming and Scripting
Dear experts,
I have a file called "check" with contents like below
i used the sed command like below to get the value of "success" and "failed" only
My question is how can i get the value to include the time "03:15", so that i can get a value such as below : -
Appreciate... (4 Replies)
Discussion started by: aismann
4 Replies
5. Shell Programming and Scripting
hi
i have file as below , i want to add duplicate records like bell_bb to one record with valuve as 15 ( addition of both )
any oneline awk script to achive this ?
header 0
CAMPAIGN_NAME 1
Bell_BB 14
Bell_MONTHLY 803
SOLO_UNBEATABLE 644
Bell_BB 1
Bell_MONTHLY 25
SOLO_UNBEATABLE... (4 Replies)
Discussion started by: raghavendra.cse
4 Replies
6. Shell Programming and Scripting
Hello,
I have a main file with IP addresses like this:
Erisim var,100,172.17.241.5,4006,60,IS0799,TCP/IP
Erisim var,1003,172.17.140.4,4004,60,IS2156,TCP/IP
Erisim var,1004,172.17.140.5,4002,60,IS2636,TCP/IP
Erisim var,1005,172.17.140.5,4004,60,IS2436,TCP/IP
Erisim... (8 Replies)
Discussion started by: Spunkerspawn
8 Replies
7. Shell Programming and Scripting
Dears,
I need a script or command which can find the unique number from the second filed and against that number it adds the total of first field .
17215630 , 0
907043 ,1
201050 ,10
394149 ,4
1964 ,9
17215630, 0
907043 ,1
201050, 10
394149 ,4
1964 ,9
1234234, 55
23 ,100
33 ,67
... (2 Replies)
Discussion started by: shary
2 Replies
8. Shell Programming and Scripting
I have a flat file
test.log
red,5,,,,,
green,7,,,,,
blue,4,,,,,
red,8,,,,,
green,9,,,,,
How i get a a result:
blue,4,,,,,
green,16,,,,,
red,13,,,,,
Thanks
Video tutorial on how to use code tags in The UNIX and Linux Forums. (2 Replies)
Discussion started by: sabercats
2 Replies
9. Shell Programming and Scripting
Hi I have file as given below
040|14300|40.0|563000
042|13200000|40.0
041|100|40.0
043|10000|40.0
045|102|40.0
I want to check
if field 4 is null then I have to place | in position 4.
result set should be
040|14300|40.0|563000
042|13200000|40.0|
041|100|40.0|
043|10000|40.0|... (9 Replies)
Discussion started by: shabeena
9 Replies
10. Shell Programming and Scripting
I have a text file in the following format
>Homo sapiens
KQKCLYNLPFKRNLEGCRERCSLVIQIPRCCKGYFGRDCQACPGGPDAPCNNRGVCLDQY
SATGECKCNTGFNGTACEMCWPGRFGPDCLPCGCSDHGQCDDGITGSGQCLCETGWTGPS
CDTQAVLPAVCTPPCSAHATCKENNTCECNLDYEGDGITCTVVDFCKQDNGGCAKVARCS... (2 Replies)
Discussion started by: jerrild
2 Replies
LEARN ABOUT OPENSOLARIS
whois
whois(1) User Commands whois(1)
NAME
whois - Internet user name directory service
SYNOPSIS
whois [-h host] identifier
DESCRIPTION
whois searches for an Internet directory entry for an identifier which is either a name (such as ``Smith'') or a handle (such as ``SRI-
NIC''). To force a name-only search, precede the name with a period; to force a handle-only search, precede the handle with an exclamation
point.
To search for a group or organization entry, precede the argument with * (an asterisk). The entire membership list of the group will be
displayed with the record.
You may of course use an exclamation point and asterisk, or a period and asterisk together.
EXAMPLES
Example 1 Using The whois Command
The command:
example% whois Smith
looks for the name or handle SMITH.
The command:
example% whois !SRI-NIC
looks for the handle SRI-NIC only.
The command:
example% whois .Smith, John
looks for the name JOHN SMITH only.
Adding ... to the name or handle argument will match anything from that point; that is, ZU ... will match ZUL, ZUM, and so on.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWrcmdc |
+-----------------------------+-----------------------------+
SEE ALSO
attributes(5)
SunOS 5.11 6 Nov 2000 whois(1)