01-26-2015
Sorry, I misunderstood your request
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have a space delimited text file that looks like the following:
Aa 100 200
Bb 300 100
Cc X 500
Dd 600 X
Basically, I want to take the average of columns 2 and 3 and print it in column 4. However if there is an X in either column 2 or 3, I want to print the non-X value. Therefore... (11 Replies)
Discussion started by: evelibertine
11 Replies
2. Shell Programming and Scripting
I have a lot of input files that have the following form:
Sample Cq Sample Cq Sample Cq Sample Cq Sample Cq
1WBIN 23.45 1WBIN 23.45 1CVSIN 23.96 1CVSIN 23.14 S1 31.37
1WBIN 23.53 1WBIN 23.53 1CVSIN 23.81 1CVSIN 23.24 S1 31.49
1WBIN 24.55 1WBIN 24.55 1CVSIN 23.86 1CVSIN 23.24 S1 31.74 ... (3 Replies)
Discussion started by: isildur1234
3 Replies
3. Shell Programming and Scripting
Hi, I need help with the awk command.
I have a folder with aprox 500 files each one with two columns and I want to print in a new file, the average of column 1 and average of column 2 and the name of each file.
Input files are:
File-1:
100 99
20 99
50 99
50 99
File-2:
200 85... (3 Replies)
Discussion started by: Lokaps
3 Replies
4. 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
5. Shell Programming and Scripting
I have the following format of input from multiple files
File 1
24.01 -81.01 1.0
24.02 -81.02 5.0
24.03 -81.03 0.0
File 2
24.01 -81.01 2.0
24.02 -81.02 -5.0
24.03 -81.03 10.0
I need to scan through the files and when the first 2 columns match I... (18 Replies)
Discussion started by: ncwxpanther
18 Replies
6. Emergency UNIX and Linux Support
Hi Friends,
I have files with columns like this. This sample input below is partial.
Please check below for main file link. Each file will have only two rows.
... (8 Replies)
Discussion started by: jacobs.smith
8 Replies
7. Shell Programming and Scripting
Hi forum members,
I'm trying to get an average of multiple columns in a csv file using awk. A small example of my input data is as follows:
cu,u3o8,au,ag
-9,20,-9,3.6
0.005,30,-9,-9
0.005,50,10,3.44
0.021,-9,8,3.35
The following code seems to do most of what I want
gawk -F","... (6 Replies)
Discussion started by: theflamingmoe
6 Replies
8. 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
9. Shell Programming and Scripting
hello, I have three files in the following order
==> File1 <==
1 20977000 20977000 A C 1.00 0,15 15 45
1 115829313 115829313 G A 0.500 6,7 13 99
==> File2 <==
1 20977000 20977000 A C 1.00 0,13 13 39
1 115829313 ... (5 Replies)
Discussion started by: nans
5 Replies
10. UNIX for Beginners Questions & Answers
I have files that have the following columns
chr pos ref alt sample 1 sample 2 sample 3
chr2 179644035 G A 1,107 0,1 58,67
chr7 151945167 G T 142,101 100,200 500,700
chr13 31789169 CTT CT,C 6,37,8 0,0,0 15,46,89
chr22 ... (3 Replies)
Discussion started by: nans
3 Replies
LEARN ABOUT OPENSOLARIS
scsi_arq_status
scsi_arq_status(9S) Data Structures for Drivers scsi_arq_status(9S)
NAME
scsi_arq_status - SCSI auto request sense structure
SYNOPSIS
#include <sys/scsi/scsi.h>
INTERFACE LEVEL
Solaris DDI specific (Solaris DDI)
DESCRIPTION
When auto request sense has been enabled using scsi_ifsetcap(9F) and the "auto-rqsense" capability, the target driver must allocate a sta-
tus area in the SCSI packet structure for the auto request sense structure (see scsi_pkt(9S)). In the event of a check condition, the
transport layer automatically executes a request sense command. This check ensures that the request sense information does not get lost.
The auto request sense structure supplies the SCSI status of the original command, the transport information pertaining to the request
sense command, and the request sense data.
STRUCTURE MEMBERS
struct scsi_status sts_status; /* SCSI status */
struct scsi_status sts_rqpkt_status; /* SCSI status of
request sense cmd */
uchar_t sts_rqpkt_reason; /* reason completion */
uchar_t sts_rqpkt_resid; /* residue */
uint_t sts_rqpkt_state; /* state of command */
uint_t sts_rqpkt_statistics;/* statistics */
struct scsi_extended_sense sts_sensedata; /* actual sense data */
sts_status is the SCSI status of the original command. If the status indicates a check condition, the transport layer might have performed
an auto request sense command.
sts_rqpkt_status is the SCSI status of the request sense command. sts_rqpkt_reason is the completion reason of the request sense command.
If the reason is not CMD_CMPLT, then the request sense command did not complete normally.
sts_rqpkt_resid is the residual count of the data transfer and indicates the number of data bytes that have not been transferred. The auto
request sense command requests SENSE_LENGTH bytes.
sts_rqpkt_state has bit positions representing the five most important statuses that a SCSI command can go obtain.
sts_rqpkt_statistics maintains transport-related statistics of the request sense command.
sts_sensedata contains the actual sense data if the request sense command completed normally.
SEE ALSO
scsi_ifgetcap(9F), scsi_init_pkt(9F), scsi_extended_sense(9S), scsi_pkt(9S)
Writing Device Drivers
SunOS 5.11 30 Sep 1996 scsi_arq_status(9S)