|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Evaluate 2 columns, add sum IF two columns match on two rows
Post 302841515 by mtucker6784 on Wednesday 7th of August 2013 12:57:22 PM
08-07-2013
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies
2. Shell Programming and Scripting
Hi all,
I have a large matrix of 720 x 25. I want to get sum of range of rows and columns. Like, I need sum of all columns and row number 2 to 21, then leaving 22nd row, again sum of all columns and row number 23 to 42 again leaving 43rd row and then sum of 44th to 63. Means I want to add all... (4 Replies)
Discussion started by: CAch
4 Replies
3. Shell Programming and Scripting
My File looks like:
"|" -> Field separator
A|B|C|100|1000
D|E|F|1|2
G|H|I|0|7
D|E|F|1|2
A|B|C|10|10000
G|H|I|0|7
A|B|C|1|100
D|E|F|1|2
I need to do a SUM on Col. 5 and Col.6 by grouping on Col 1,2 & 3
My expected output is:
A|B|C|111|11100 (2 Replies)
Discussion started by: machomaddy
2 Replies
4. Shell Programming and Scripting
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies
5. Shell Programming and Scripting
Hello Friends,
I have a input file having hundreds of rows. I want them to translate in to columns if column 1 is same.
Input data:
zp06 xxx
zp06 rrr
zp06 hhh
zp06 aaa
zp06 ggg
zp06 qwer
zp06 ser
zl11 old3
zl11 old4
zl11 old5
zl11 old6
zl11 old7
zm14 luri
zm14 body
zm14 ucp (9 Replies)
Discussion started by: suresh3566
9 Replies
6. Shell Programming and Scripting
Hi,
I am a new bie i need some help with respect to shell onliner;
I have data in following format
Name FromDate UntilDate Active Changed Touched
Test 28-03-2013 28-03-2013 1 0.6667 100
Test2 28-03-2013 03-04-2013 ... (1 Reply)
Discussion started by: gangaraju6
1 Replies
7. Shell Programming and Scripting
Hello All,
I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns.
So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Discussion started by: vikas_trl
7 Replies
8. Shell Programming and Scripting
HI All,
I'm embedding SQL query in Script which gives following output:
Assignee Group Total
ABC Group1 17
PQR Group2 5
PQR Group3 6
XYZ Group1 10
XYZ Group3 5
I have saved the above output in a file.
How do i sum up the contents of this output so as to get following output:
... (4 Replies)
Discussion started by: Khushbu
4 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I wanted to merge the content and below is input and required output info.
Input:
/hello,a,r
/hello,a,L
/hello,a,X
/hi,b,v
/hi,b,c
O/p:
/hello,a,r:L:X
/hi,v,:v:c
Use code tags, thanks. (6 Replies)
Discussion started by: ankitas
6 Replies
10. UNIX for Beginners Questions & Answers
Dear Experts,
I have input file which is comma separated, has 4 columns like below,
BRAND,COUNTRY,MODEL,COUNT
NIKE,USA,DUMMY,5
NIKE,USA,ORIGINAL,10
PUMA,FRANCE,DUMMY,20
PUMA,FRANCE,ORIGINAL,15
ADIDAS,ITALY,DUMMY,50
ADIDAS,ITALY,ORIGINAL,50
SPIKE,CHINA,DUMMY,1O
And expected output add... (2 Replies)
Discussion started by: ricky1991
2 Replies
LEARN ABOUT DEBIAN
astribank_tool
ASTRIBANK_TOOL(8) ASTRIBANK_TOOL(8) NAME
astribank_tool - Xorcom Astribank (xpp) control tool SYNOPSIS
astribank_tool [ options ] [ operation... ] -D device-path astribank_tool [-h] DESCRIPTION
astribank_tool is a tool to control the USB-level functionality of an Astribank. The tool operates on a single Astribank at a time (given as parameter to the -D command line option). OPTIONS
-D device-path Required. The device to read from/write to. This is bus_num/device_num, where bus_num and device_num are the first two numbers in the output of lsusb(8) or dahdi_hardware(8). On older versions of this toolyou needed a complete path to the device, which would be /dev/bus/usb/bus_num/device_num, or /proc/bus/usb/bus_num/device_num. -p num Set the TwinStar port number. Either 0 or 1. (TODO: explain). -r type Reset the Astribank and renumerate its USB connection to power on product ID. Tyep can be: half or full. (TODO: explain those). -w 0|1 Enable (1) or disable (0) the TwinStar watchdog. When enabled, the Astribank will jump to the second port if this system is "not working" and the system on the second port is available. -Q Query astribank properties via MPP protocol. -n Renumerate the Astribank product number (e.g: from 1161 to 1162). -v Increase verbosity. May be used multiple times. -d mask Set debug mask to mask. Default is 0, 0xFF is "everything". -h Displays usage message. SEE ALSO
fxload(8), lsusb(8), astribank_hexload(8) AUTHOR
This manual page was written by Tzafrir Cohen <tzafrir.cohen@xorcom.com> . Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later version published by the Free Software Foundation. On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL. 29 March 2009 ASTRIBANK_TOOL(8)