|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Do replace operation and awk to sum multiple columns if another column has duplicate values
Post 303016878 by as7951 on Saturday 5th of May 2018 06:28:34 AM
05-05-2018
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have some data that is something like this?
item: onhand counted location
ITEM0001 1 0 a1
ITEM0001 0 1 a2
ITEM0002 5 0 b5
ITEM0002 0 6 c1
I want to sum up... (6 Replies)
Discussion started by: syadnom
6 Replies
2. Shell Programming and Scripting
i have a file - it will be in sorted order on column 1
abc 0 1
abc 2 3
abc 3 5
def 1 7
def 0 1
--------
i'd like (awk maybe?) to get the results (any ideas)???
abc 5 9
def 1 8 (2 Replies)
Discussion started by: jjoe
2 Replies
3. Shell Programming and Scripting
I have file which as 12 columns and values like this
1,2,3,4,5
a,b,c,d,e
b,c,a,e,f
a,b,e,a,h
if you see the first column has duplicate values, I need to identify (print it to console) the duplicate value (which is 'a') and also remove duplicate values like below. I could be in two... (5 Replies)
Discussion started by: nuthalapati
5 Replies
4. Shell Programming and Scripting
I've a text file with below values viz. multiple rows with same values in column 3, 4 and 5, which need to be considered as duplicates. For all such cases, the rows from second occurrence onwards should be modified in a way that their values in first two columns are replaced with values as in first... (4 Replies)
Discussion started by: asyed
4 Replies
5. UNIX for Dummies Questions & Answers
Hello,
I am new to Linux environment , I working on Linux script which should send auto email based on the specific condition from log file. Below is the sample log file
Name m/c usage
abc xxx 10
abc xxx 20
abc xxx 5
xyz ... (6 Replies)
Discussion started by: asjaiswal
6 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
I have a file (let say file B) like this:
File B:
A1 3 5
A1 7 9
A2 2 5
A3 1 3
The first column defines a filename and the other two define a range in that specific file. In the same directory, I have also three more files (File A1, A2 and A3). Here is 10 sample lines... (3 Replies)
Discussion started by: Bastami
3 Replies
8. Shell Programming and Scripting
I need to sum values in text file in case duplicate row are present with same name and different value below is example of data in file i have and format i need.
Data in text file
20170308
PM,U,2
PM,U,113
PM,I,123
DA,U,135
DA,I,113
DA,I,1
20170309
PM,U,2
PM,U,1
PM,I,123
PM,I,1... (3 Replies)
Discussion started by: Adfire
3 Replies
9. Shell Programming and Scripting
awk to Sum columns when other column has duplicates and append one column value to another with Care
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
10. UNIX for Beginners Questions & Answers
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)
Discussion started by: Tahir_M
6 Replies
LEARN ABOUT DEBIAN
pamusb-check
pamusb-check(1) PAM_USB pamusb-check(1) NAME
pamusb-check - simulates pam_usb authentication SYNOPSIS
Usage: pamusb-check [--help] [--debug] [--config=path] [--service=name] [--dump] [--quiet] <username> DESCRIPTION
pamusb-check can simulate authentication through the pam_usb engine. It is useful for both testing purposes (to check the pam_usb configu- ration without having to try with a real program), but also for scripting. pamusb-check's exit code is 0 if the authentication was success- ful, 1 otherwise. It is used by pamusb-agent to check the device. EXAMPLES
$ pamusb-check scox o Authentication request for user "scox" (pamusb-check) o Device "creative" is connected (good). o Access granted. $ pamusb-check --service=su scox o Authentication request for user "scox" (su) o Device "creative" is connected (good). o Access granted. $ pamusb-check --dump scox Configuration dump for user scox (service: pamusb-check): enable : true debug : false quiet : false color_log : true one_time_pad : true probe_timeout : 10 hostname : helium system_pad_directory : .pamusb device_pad_directory : .pamusb OPTIONS
--help, -h Show summary of options. --debug, -D Shows debug messages. --config, -c Use the given configuration file (defaults to /etc/pamusb.conf). --service, -s Service name to be used for authentication (defaults to pamusb-check) --dump, -d Dump the configuration, but do not try to authenticate --quiet, -q Quiet mode BUGS
Please send bug reports to the pam_usb mailing list. AUTHOR
Andrea Luzzardi <scox@sig11.org> September 12, 2007 pamusb-check(1)