Below Awk sum the value correctly based on username, but not dividing the sum of values based on number of rows of user name. I need something like
root 50 oracle 75 .......can anyone shed some light please?
Hello,
Could some expert soul please help me with this? I have following file format -
task time
abc 5
xyz 4
abc 5
xyz 3
ddd 10
ddd 2
I need to generate output as -
task ... (5 Replies)
Hello,
I am having 1800 files in a directory with a specified format, like
amms_850o_prod.000003uNy
amms_850o_prod.000003u8x
amms_850o_prod.000003taP
amms_850o_prod.000003tKy
amms_850o_prod.000003si4
amms_850o_prod.000003sTP
amms_850o_prod.000003sBg
amms_850o_prod.000003rvx... (12 Replies)
not sure if it's called "group by" , but what i'm going to do is like this:
i have a file below:
192.168.1.10
192.168.1.10
192.168.1.10
192.168.1.11
192.168.1.15
192.168.1.15
192.168.1.20
192.168.1.22
then i hope to get the result like this:
192.168.1.10 : 3
192.168.1.11 : 1... (6 Replies)
Hi,
When I include a user to the secondary group "sys" GID=3 in Solaris 9 OS I'm not able to login. I get these error. The user home directory and the shell exists. Is this because of any security hardening.
# su - agent
No directory!
# su agent
su: No shell
# grep taddm /etc/passwd... (14 Replies)
Hi,
I have a following file:
role.IMPACT_USER.user=admin
role.IMPACT_USER.user=dd12345
role.IMPACT_USER.user=ss76767
#role.IMPACT_USER.user=root
#role.IMPACT_USER.group=System
role.IMPACT_USER.group=ImpactUser
#Description: Allow users to login in to Impact, start and stop service... (5 Replies)
I am having some problems when writing shell as follows:
shell runs but returns no results
echo "enter group name: "
dir="/home"
read group
if id -g $group > /dev/null 2>&1
then
echo "group exits"
else
echo... (6 Replies)
Hi All,
I want to display the distinct values in the file and for each distinct value how may occurance or there.
Test data:
test1.dat
20121105
20121105
20121105
20121105
20121106
20121106
20121106
20121105
I need to display the output like
Output (2 Replies)
Hi,
I want to know if there is any simple approach to SUM a field based on group by of different fields
for e.g.
file1.txt contains below data
20160622|XXX1||50.00||50.00|MONEY|Plan1|
20160622|XXX1||100.00||100.00|MONEY|Plan1|
20160623|XXX1||25.00||25.00|MONEY|Plan1|... (3 Replies)
Hello All,
I saw this problem on one of the forum and solved it using group-by in oracle sql, though I am a bit curious to implement it using shell script :
There is a file having number of operations :
Opeation,Time-Taken
operation1,83621
operation2,72321
operation3,13288... (11 Replies)
Discussion started by: mukulverma2408
11 Replies
LEARN ABOUT OPENSOLARIS
sum
sum(1) User Commands sum(1)NAME
sum - print checksum and block count for a file
SYNOPSIS
sum [-r] [file]...
DESCRIPTION
The sum utility calculates and prints a 16-bit checksum for the named file and the number of 512-byte blocks in the file. It is typically
used to look for bad spots, or to validate a file communicated over some transmission line.
OPTIONS
The following options are supported:
-r Use an alternate (machine-dependent) algorithm in computing the checksum.
OPERANDS
The following operands are supported:
file A path name of a file. If no files are named, the standard input is used.
USAGE
See largefile(5) for the description of the behavior of sum when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes).
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of sum: LC_CTYPE, LC_MESSAGES, and
NLSPATH.
EXIT STATUS
The following exit values are returned.
0 Successful completion.
>0 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------------------------------------+
| ATTRIBUTE TYPE ATTRIBUTE VALUE |
|Availability SUNWesu |
|CSI Enabled |
+-----------------------------------------------------------+
SEE ALSO cksum(1), sum(1B), wc(1), attributes(5), environ(5), largefile(5)DIAGNOSTICS
Read error is indistinguishable from end of file on most devices. Check the block count.
NOTES
Portable applications should use cksum(1).
sum and usr/ucb/sum (see sum(1B)) return different checksums.
SunOS 5.11 7 Nov 1995 sum(1)