02-27-2012
Thanks to you both! I only tried bartus11's response and it seems to have worked perfectly!
---------- Post updated at 06:28 PM ---------- Previous update was at 10:58 AM ----------
Sorry one last request as I seem to be suffering from rounding errors. Is it possible to incorporate a rule into the commands suggested that if the newly generated columns are negative (i.e. the sums of the two preceding columns used to generate the value are greater than one) they should be set instead to zero?
Thanks again!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I have a matrix 200*10,000 and I need to extract the columns between 40 and 77. I dont want to write in awk all the columns. eg: awk '{print $40, $41, $42,$43 ... $77}'. I think should exist a better way to do this. (10 Replies)
Discussion started by: auratus42
10 Replies
2. Shell Programming and Scripting
AWK subtraction in multiple columns
Hi there,
Can not get the following:
input: 34523 934
9485 3847
394 3847
3456 9384
awk 'NR==1 {for (i = 1; i <= NF; i++) {n=$i; next}; {n-=$i} END {print n}' input
output: 21188 first column only,... (2 Replies)
Discussion started by: awkward
2 Replies
3. UNIX for Dummies Questions & Answers
Hi,
Our requirement is we have to create file from one file where all the rows from source file is converted into columns of the target file.
For example
Source file is :
Status Report ABC
Generated: 2009-05-05 08:49:47
Job start time=2009-05-05 08:43:43
Job end time=2009-05-05... (1 Reply)
Discussion started by: Amey Joshi
1 Replies
4. Shell Programming and Scripting
I can't seem to get this to work.
I can reformat the date field if it's the first field (and only field) in the file:
However, I get a syntax error when the date field is the second field (or has any other columns following):
I can use a ";" but then it puts each column on separate... (8 Replies)
Discussion started by: giannicello
8 Replies
5. Shell Programming and Scripting
Hi,
Input
7488 7389 chr1.fa chr1.fa
3546 9887 chr5.fa chr9.fa
7387 7898 chrX.fa chr3.fa
7488 7389 chr21.fa chr3.fa
7488 7389 chr1.fa chr1.fa
3546 9887 chr9.fa chr5.fa
7898 7387 chrX.fa chr3.fa
Desired Output
7488 7389 chr1.fa chr1.fa 2
3546 9887 chr5.fa chr9.fa 2... (2 Replies)
Discussion started by: jacobs.smith
2 Replies
6. Shell Programming and Scripting
Hi everyone!!
I need to apply a simple command to extract columns from a matrix, but I need to extract contemporary from the first to the tenth columns, than from the eleventh to the twentyth and so on...
how can i do that? (1 Reply)
Discussion started by: gabrysfe
1 Replies
7. Shell Programming and Scripting
Is it possible to join all the values after sorting them based on 1st column key and replace empty rows with 0 like below ?
input
a1 0 a1 1 a1 1 a3 1 b2 1
a2 1 a4 1 a2 1 a4 1 c4 1
a3 1 d1 1 a3 1 b1 1 d1 1
a4 1 c4 1 b2 1
b1 1
b2 1
c4 1
d1 1
output... (8 Replies)
Discussion started by: quincyjones
8 Replies
8. Shell Programming and Scripting
Hi guys,
I have hundreds file like this, here I only show two of them:
file 1
feco4_s_BB95.log ZE_1=-1717.5206260
feco4_t_BB95.log ZE_1=-1717.5169250
feco5_s_BB95.log ZE_1=-1830.9322060... (11 Replies)
Discussion started by: liuzhencc
11 Replies
9. Shell Programming and Scripting
Hello All;
I have two files with below conditions:
1. Entries in file A is missing in file B (primary is field 1)
2. Entries in file B is missing in file A (primary is field 1)
3. Field 1 is present in both files but Field 2 is different.
Example Content:
File A
... (4 Replies)
Discussion started by: mystition
4 Replies
10. 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
LEARN ABOUT OPENSOLARIS
partx
PARTX(8) System Administration PARTX(8)
NAME
partx - tell the kernel about the presence and numbering of on-disk partitions
SYNOPSIS
partx [-a|-d|-P|-r|-s|-u] [-t type] [-n M:N] [-] disk
partx [-a|-d|-P|-r|-s|-u] [-t type] partition [disk]
DESCRIPTION
Given a device or disk-image, partx tries to parse the partition table and list its contents. It can also tell the kernel to add or remove
partitions from its bookkeeping.
The disk argument is optional when a partition argument is provided. To force scanning a partition as if it were a whole disk (for example
to list nested subpartitions), use the argument "-" (hyphen-minus). For example:
partx --show - /dev/sda3
This will see sda3 as a whole-disk rather than as a partition.
partx is not an fdisk program - adding and removing partitions does not change the disk, it just tells the kernel about the presence and
numbering of on-disk partitions.
OPTIONS
-a, --add
Add the specified partitions, or read the disk and add all partitions.
-b, --bytes
Print the SIZE column in bytes rather than in human-readable format.
-d, --delete
Delete the specified partitions or all partitions.
-g, --noheadings
Do not print a header line with --show or --raw.
-l, --list
List the partitions. Note that all numbers are in 512-byte sectors. This output format is DEPRECATED in favour of --show. Do not
use it in newly written scripts.
-n, --nr M:N
Specify the range of partitions. For backward compatibility also the format M-N is supported. The range may contain negative num-
bers, for example --nr -1:-1 means the last partition, and --nr -2:-1 means the last two partitions. Supported range specifications
are:
M Specifies just one partition (e.g. --nr 3).
M: Specifies the lower limit only (e.g. --nr 2:).
:N Specifies the upper limit only (e.g. --nr :4).
M:N Specifies the lower and upper limits (e.g. --nr 2:4).
-o, --output list
Define the output columns to use for --show, --pairs and --raw output. If no output arrangement is specified, then a default set is
used. Use --help to get list of all supported columns. This option cannot be combined with the --add, --delete, --update or --list
options.
-P, --pairs
List the partitions using the KEY="value" format.
-r, --raw
List the partitions using the raw output format.
-s, --show
List the partitions. The output columns can be selected and rearranged with the --output option. All numbers (except SIZE) are in
512-byte sectors.
-t, --type type
Specify the partition table type.
--list-types
List supported partition types and exit.
-u, --update
Update the specified partitions.
-S, --sector-size size
Overwrite default sector size.
-v, --verbose
Verbose mode.
-V, --version
Display version information and exit.
-h, --help
Display help text and exit.
EXAMPLES
partx --show /dev/sdb3
partx --show --nr 3 /dev/sdb
partx --show /dev/sdb3 /dev/sdb
All three commands list partition 3 of /dev/sdb.
partx --show - /dev/sdb3
Lists all subpartitions on /dev/sdb3 (the device is used as whole-disk).
partx -o START -g --nr 5 /dev/sdb
Prints the start sector of partition 5 on /dev/sdb without header.
partx -o SECTORS,SIZE /dev/sda5 /dev/sda
Lists the length in sectors and human-readable size of partition 5 on /dev/sda.
partx --add --nr 3:5 /dev/sdd
Adds all available partitions from 3 to 5 (inclusive) on /dev/sdd.
partx -d --nr :-1 /dev/sdd
Removes the last partition on /dev/sdd.
SEE ALSO
addpart(8), delpart(8), fdisk(8), parted(8), partprobe(8)
AUTHORS
Davidlohr Bueso <dave@gnu.org>
Karel Zak <kzak@redhat.com>
The original version was written by Andries E. Brouwer <aeb@cwi.nl>.
ENVIRONMENT
LIBBLKID_DEBUG=all
enables libblkid debug output.
AVAILABILITY
The partx command is part of the util-linux package and is available from Linux Kernel Archive <https://www.kernel.org/pub/linux/utils
/util-linux/>.
util-linux December 2014 PARTX(8)