Sum numeric columns contained in a plain text file
Hi everyone,
Here are the contents of a plain text file created by a SQL query:
How can I sum the numeric columns to get the following result? No need to solve the problem for me. Just point me in the right direction and I'll be more than thankful .
I'm in Red Hat Enterprise Linux Server release 5.7 (Tikanga) and using GNU bash, version 3.2.25(1)-release (i386-redhat-linux-gnu).
Thanks in advance!
Is there a way i can take 'lets say the etc/group file' and arange the group names into a selectable numeric menu eg;
1) root:0
2) other:1
3) bin:2
4) sys:3
.....
.....
.....
and so on
then
GROUP="group name of users selection"
i have tried for over an hour searching on... (6 Replies)
Hi All,
happy new year.
I have a file with 4xN columns like
0.0000e+00 0.0000e+00 7.199E+07 7.123E+07 6.976E+07 6.482E+07 5.256E+07 2.523E+07
0.0000e+00 0.0000e+00 8.641E+07 8.550E+07 8.373E+07 7.780E+07 6.309E+07 3.028E+07... (8 Replies)
Hi all,
I have following scenario to perform sum aggregation on certain columns
Node Allocated_Space Pool_Name CS_Group Utilized Space
-------- ---------------- ---------- --------- --------------
bdw1a_lun01 300 bdw_p0 ... (2 Replies)
Hi,
I need to do a sum of two columns in a file where delimiter is |^
input
1|^2|^3|^4|^50|^2|^3|^100
2|^3|^4|^6|^100|^7|^2|^50
3|^4|^2|^3|^50|^6|^3|^50
4|^2|^5|^7|^25|^2|^8|^25
Output required:
Sum of 2 columns 5 & 8 which is 450 (11 Replies)
Hi everyone,
I want to know, if there is a way to modify one line in a text file with unix script, with out re-writing all the file.
For example, i have this file:
CONFIGURATION_1=XXXX
CONFIGURATION_2=YYYY
CONFIGURATION_3=ZZZZ
supose i have a command or function "modify" that... (7 Replies)
Hi all, I know this sounds suspiciously like a homework course; but, it is not.
My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
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)
I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv
abc.csv-
UTF-8,,,,,,,,,,,,,,,,,,,,,,,,,
... (6 Replies)
Optimization shell/awk script to aggregate (sum) for all the columns of Huge data file
File delimiter "|"
Need to have Sum of all columns, with column number : aggregation (summation) for each column
File not having the header
Like below -
Column 1 "Total
Column 2 : "Total
...
...... (2 Replies)
Discussion started by: kartikirans
2 Replies
LEARN ABOUT REDHAT
rhn_check
RHN_CHECK(8) Red Hat Network RHN_CHECK(8)NAME
rhn_check - check for queued actions on RHN and execute them
SYNOPSIS
/usr/sbin/rhn_check [-v] [--verbose]
DESCRIPTION
rhn_check is a client program that connects to the Red Hat Network backend servers and retrieves information associated with the queued
actions for this particular system. This script reads the digital server ID from /etc/sysconfig/rhn/systemid and uses that to identify the
machine to the Red Hat Network. Upon successfull authentication, rhn_check will start processing the queued actions sequentially.
ACTION TYPES
The following types of actions are currently processed by rhn_check:
action type description
() ()
refresh This action will refresh the hardware or software profiles of this
machine with Red Hat Network. This fucntion is called as
refresh(hardware) or refresh(rpmlist)
new_systemid This action is used by the RHn Backend to update the Digital
system ID of this machine with a new one.
update_packages This action will trigger rhn_check into running a package
update for a list of packages queued from the Red Hat Network.
rhn_check will use modules from the up2date client to download
the packages, solve dependencies and install the on the system.
FILES
/etc/sysconfig/rhn/systemid The digital server ID for this machine if the system has been registered onto Red Hat Network. This file does
not exist otherwise.
/var/spool/up2date This directory is used by up2date to store package headers and RPM packages downloaded from Red Hat Network
SEE ALSO
man pages for up2date(8) and rhnsd(8).
AUTHORS
Cristian Gafton <gafton@redhat.com>
Preston Brown <pbrown@redhat.com>
()