Could you please try following and let me know if this helps you.
Let me know how it goes then. Also I would say you could test this command in few test files, once you are happy with it then you could give it a shot for real files.
Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
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)
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)
I have a dataset with 120 columns. I would like to write a script, that takes the average of every two columns, starting from columns 2 and 3, and moving consecutively in frames of 3 columns, all the way until the last column.
The first column in the output file would be the averages of columns... (1 Reply)
Hi experts,
I want to group by average, for multiple columns starting column $7 until NF,
group by ($1-$5), please help
For just 7th column, I can do
awk '
NR>1{
arr += $7
count += 1
}
END{
for (a in arr) {
print a, arr/count
... (10 Replies)
I have the need to match the first two columns and when they match, calculate the percent of average for the third columns. The following awk script does not give me the expected results.
awk 'NR==FNR {T=$3; next} $1,$2 in T {P=T/$3*100; printf "%s %s %.0f\n", $1, $2, (P>=0)?P:-P}' diff.file... (1 Reply)
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)
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)
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)
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
sccs-val
sccs-val(1) User Commands sccs-val(1)NAME
sccs-val, val - validate an SCCS file
SYNOPSIS
val [-s] [-m name] [-rsid] [-y type] s.filename...
DESCRIPTION
The val utility determines if the specified s.files meet the characteristics specified by the indicated arguments. val can process up to 50
files on a single command line.
val has a special argument, `-', which reads the standard input until the end-of-file condition is detected. Each line read is indepen-
dently processed as if it were a command line argument list.
val generates diagnostic messages on the standard output for each command line and file processed and also returns a single 8-bit code upon
exit as described below.
The 8-bit code returned by val is a disjunction of the possible errors, that is, it can be interpreted as a bit string where (moving from
left to right) the bits set are interpreted as follows:
bit 0 = missing file argument
bit 1 = unknown or duplicate option
bit 2 = corrupted s.file
bit 3 = can not open file or file not in s.file format
bit 4 = the SCCS delta ID (SID) is invalid or ambiguous
bit 5 = the SID does not exist
bit 6 = mismatch between Y% and -y argument
bit 7 = mismatch between sccs-val.1 and -m argument
val can process two or more files on a given command line, and in turn can process multiple command lines (when reading the standard
input). In these cases, an aggregate code is returned which is the logical OR of the codes generated for each command line and file pro-
cessed.
OPTIONS
The following options are supported:
-s Silent. Suppresses the normal error or warning messages.
-m name Compares name with the %M% ID keyword in the s.file.
-rsid Checks to see if the indicated SID is ambiguous, invalid, or absent from the s.file.
-y type Compares type with the %Y% ID keyword.
ENVIRONMENT VARIABLES
See environ(5) for descriptions of the following environment variables that affect the execution of val: LANG, LC_ALL, LC_CTYPE, LC_MES-
SAGES, and NLSPATH.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWsprot |
+-----------------------------+-----------------------------+
|Interface Stability |Committed |
+-----------------------------+-----------------------------+
|Standard |See standards(5). |
+-----------------------------+-----------------------------+
SEE ALSO sccs(1), sccs-admin(1), sccs-delta(1), sccs-get(1), sccs-help(1), what(1), sccsfile(4), attributes(5), environ(5), standards(5)DIAGNOSTICS
Use the SCCS help command for explanations (see sccs-help(1)).
SunOS 5.11 17 Jan 2008 sccs-val(1)