02-16-2009
Column sum group by uniq records
Hi Jadu,
I am new to unix and i have a similar requirement given below:
Input file:
Test.txt
PORT; ID; TOTAL
port1;p1;100000
port2;p2;5000
port1;p1;500
Output file:
PORT; ID; TOTAL
port1;p1; 100500
port2;p2; 5000
How can achive this? Any help on this regard is higly appreciated.
Thanks.
Regards,
Sandeep
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
i have a file where the records are like this.
vt100 2048 D402 MG0010 0
586 262144 D403 MG0011 1000
486 8192 D404 MG0012 270
386 8192 A423 CC0177 40
586 65536 A424 CC0182 670
486 16384 A423 CC0183 100
486 16384 A425 CC0184 80
65000 4096 B407 EE1027 80
I want firstly,
to count how... (10 Replies)
Discussion started by: sickboy
10 Replies
2. Shell Programming and Scripting
I have a file in the following format. Groups of data merge together and the group number is indicated above each group.
1
adrf
dfgr
dfg
2
dfgr
dfgr
3
dfef
dfr
fd
4
fgrt
fgr
fgg
5
fgrt
fgr (3 Replies)
Discussion started by: Lucky Ali
3 Replies
3. Shell Programming and Scripting
Hi All
I do have a file like this with 6 columns. Groups of data merge together and the group number is indicated above each group.
1
1 12 26 289 3.2e-027 GCGTATGGCGGC
2 12 26 215 6.7e+006 TTCCACCTTTTG
3 9 26 175 ... (1 Reply)
Discussion started by: Lucky Ali
1 Replies
4. Shell Programming and Scripting
Hello All ,
I have a problem with summing of column by group
Input File -
COL_1,COL_2,COL_3,COL_4,COL_5,COL_6,COL_7,COL_8,COL_9,COL_10,COL_11
3010,21,1923D ,6,0,0.26,0,0.26,-0.26,1,200807
3010,21,192BI ,6,24558.97,1943.94,0,1943.94,22615.03,1,200807
3010,21,192BI... (8 Replies)
Discussion started by: jambesh
8 Replies
5. Shell Programming and Scripting
12-11-2012,PNL,158406
12-11-2012,RISK,4564
12-11-2012,VAR_1D,310101
12-11-2012,VAR_10D,310101
12-11-2012,CB,866
12-11-2012,STR_VAR_1D,298494
12-11-2012,STR_VAR_10D,309623
09-11-2012,PNL,1024106
09-11-2012,RISK,4565
09-11-2012,VAR_1D,317211
09-11-2012,VAR_10D,317211
09-11-2012,CB,985... (7 Replies)
Discussion started by: manas_ranjan
7 Replies
6. Shell Programming and Scripting
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
Discussion started by: prashob123
5 Replies
7. Shell Programming and Scripting
Hi,
I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column)
The input is for example, after sorted:
K00001 1 1 4 3... (8 Replies)
Discussion started by: sargotrons
8 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record.
For example, let's assume for column D... (9 Replies)
Discussion started by: tpk
9 Replies
9. Shell Programming and Scripting
I want to bring values in the second column into single line for uniq value in the first column.
My input
jvm01, Web 2.0 Feature Pack Library
jvm01, IBM WebSphere JAX-RS
jvm01, Custom01 Shared Library
jvm02, Web 2.0 Feature Pack Library
jvm02, IBM WebSphere JAX-RS
jvm03, Web 2.0 Feature... (10 Replies)
Discussion started by: kchinnam
10 Replies
10. Shell Programming and Scripting
Hi Experts,
Please bear with me, i need help
I am learning AWk and stuck up in one issue.
First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique.
Second point : For... (1 Reply)
Discussion started by: as7951
1 Replies
LEARN ABOUT FREEBSD
mount_smbfs
MOUNT_SMBFS(8) BSD System Manager's Manual MOUNT_SMBFS(8)
NAME
mount_smbfs -- mount a shared resource from an SMB file server
SYNOPSIS
mount_smbfs [-E cs1:cs2] [-I host] [-L locale] [-M crights:srights] [-N] [-O cowner:cgroup/sowner:sgroup] [-R retrycount] [-T timeout]
[-U username] [-W workgroup] [-c case] [-d mode] [-f mode] [-g gid] [-n opt] [-u uid] //user@server[:port1[:port2]]/share node
DESCRIPTION
The mount_smbfs command mounts a share from a remote server using SMB/CIFS protocol.
The options are as follows:
-E cs1:cs2
Specifies local (cs1) and server's (cs2) character sets.
-I host
Do not use NetBIOS name resolver and connect directly to host, which can be either a valid DNS name or an IP address.
-L locale
Use locale for lower/upper case conversion routines. Set the locale for case conversion. By default, mount_smbfs tries to use an
environment variable LC_* to determine it.
-M crights:srights
Assign access rights to the newly created connection.
-N Do not ask for a password. At run time, mount_smbfs reads the ~/.nsmbrc file for additional configuration parameters and a password.
If no password is found, mount_smbfs prompts for it.
-O cowner:cgroup/sowner:sgroup
Assign owner/group attributes to the newly created connection.
-R retrycount
How many retries should be done before the SMB requester decides to drop the connection. Default is 4.
-T timeout
Timeout in seconds for each request. Default is 15.
-U username
Username to authenticate with.
-W workgroup
This option specifies the workgroup to be used in the authentication request.
-c case
Set a case option which affects name representation. case can be one of the following:
Value Meaning
l All existing file names are converted to lower case. Newly created file gets a lower case.
u All existing file names are converted to upper case. Newly created file gets an upper case.
-f mode, -d mode
Specify permissions that should be assigned to files and directories. The values must be specified as octal numbers. Default value
for the file mode is taken from mount point, default value for the directory mode adds execute permission where the file mode gives
read permission.
Note that these permissions can differ from the rights granted by SMB server.
-u uid, -g gid
User ID and group ID assigned to files. The default are owner and group IDs from the directory where the volume is mounted.
//user@server[:port1[:port2]]/share
The mount_smbfs command will use server as the NetBIOS name of remote computer, user as the remote user name and share as the
resource name on a remote server. Optional port1 and port2 arguments can be used to override default values of port numbers used by
communication protocols. For SMB over NetBIOS default value for port1 are 139, and port2 are 137.
node Path to mount point.
FILES
~/.nsmbrc Keeps static parameters for connections and other information. See /usr/share/examples/smbfs/dot.nsmbrc for details.
EXAMPLES
The following example illustrates how to connect to SMB server SAMBA as user GUEST, and mount shares PUBLIC and TMP:
mount_smbfs -I samba.mydomain.com //guest@samba/public /smb/public
mount_smbfs -I 192.168.20.3 -E koi8-r:cp866 //guest@samba/tmp /smb/tmp
It is also possible to use fstab(5) for smbfs mounts (the example below doesn't prompt for a password):
//guest@samba/public /smb/public smbfs rw,noauto,-N 0 0
AUTHORS
Boris Popov <bp@butya.kz>, <bp@FreeBSD.org>
BUGS
Please report bugs to the author.
BSD
September 17, 2011 BSD