09-13-2009
extracting columns with awk
Friends, I have a file with fileds in the following order
sda 4.80 114.12 128.69 978424 1103384
sdb 0.03 0.40 0.00 3431 0
sda 1.00 0.00 88.00 0 176
sdb 0.00 0.00 0.00 0 0
sda 1.00 0.00 88.00 0 176
sdb 0.00 0.00 0.00 0 0
Now what i want is to sum up the values in 2nd column 2 rows at a time like first sum will be 4.80 + .03. 2nd will be 1.00 + 0.00. and so on. Pls can u advice me how i can acheive this.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I have a file having around 8 columns spereated by space . Now that I need to extract columns from this. The problem is this functionality is needed in a script and the required columns are dynamic and can range from 2 columns to 8 columns at a time .
What I tried without luck is ... (6 Replies)
Discussion started by: praveenbvarrier
6 Replies
2. 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
3. Shell Programming and Scripting
The output of the below command is :
# yum -e0 -d0 check-update
dnsmasq.i386 2.45-1.1.el5_3 updates
ecryptfs-utils.i386 75-5.el5 updates
fetchmail.i386 6.3.6-1.1.el5_3.1 updates... (16 Replies)
Discussion started by: proactiveaditya
16 Replies
4. Shell Programming and Scripting
Hi All,
I have a text file which looks like below.
################################################
Name:xxxxxxx
Version:1.0
Class: 2
City : Bangalore
Component Part Action Nb New Part Naming Part Name
12345 default 12345.12345 Bad
23456 ... (6 Replies)
Discussion started by: smarty86
6 Replies
5. Shell Programming and Scripting
Hi,
snp.txt
CHR_A SNP_A BP_A_st BP_A_End CHR_B BP_B SNP_B R2 p-SNP_A p-SNP_B
5 rs1988728 74904317 74904318 5 74960646 rs1427924 0.377333 0.000740085 0.013930081
5 ... (12 Replies)
Discussion started by: genehunter
12 Replies
6. UNIX for Dummies Questions & Answers
hi everyone!
I already posted it in scripts, I'm sorry, it's doubled
I'd like to extract a single column from 5 different files and put them together in an output file. I saw a similar question for 2 input files, and the line of code workd very well, the code is:
awk 'NR==FNR{a=$2; next}... (1 Reply)
Discussion started by: orcaja
1 Replies
7. Shell Programming and Scripting
hi everyone!
I'd like to extract a single column from 5 different files and put them together in an output file. I saw a similar question for 2 input files, and the line of code workd very well, the code is:
awk 'NR==FNR{a=$2; next} {print a, $2}' file1 file2
I added the file3, file4 and... (10 Replies)
Discussion started by: orcaja
10 Replies
8. Shell Programming and Scripting
Hello,
I am obviously quite new to unix and awk. I need to parse certain columns of a file (delimited by spaces), and somehow save the value of this column somewhere, together with the value of the column just after it (by pairs; so something like ).
I'm then supposed to count the times that... (9 Replies)
Discussion started by: acsg
9 Replies
9. 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
10. Shell Programming and Scripting
Hello All
I'm joining two files using Awk by Left outer join on the file 1
File 1
1 AA
2 BB
3 CC
4 DD
File 2
1 IND 100 200 300
2 AUS 400 500 600
5 USA 700 800 900 (18 Replies)
Discussion started by: venkat_reddy
18 Replies
PARTX(8) System Manager's Manual PARTX(8)
NAME
partx - tell the Linux kernel about the presence and numbering of on-disk partitions
SYNOPSIS
partx [-a|-d|-s] [-t TYPE] [-n M:N] [-] disk
partx [-a|-d|-s] [-t TYPE] partition [disk]
DESCRIPTION
Given a device or disk-image, partx tries to parse the partition table and list its contents. It optionally adds or removes partitions.
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 "-". For example:
partx --show - /dev/sda3
This will see sda3 as a whole-disk rather than a partition.
This 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.
-l, --list
List the partitions. Note that all numbers are in 512-byte sectors. This output format is DEPRECATED in favour of --show. Don't
use it in newly written scripts.
-o, --output list
Define the output columns to use for --show and --raw output. If no output arrangement is specified, then a default set is used.
Use --help to get list of all supported columns.
-r, --raw
Use the raw output format.
-s, --show
List the partitions. All numbers (except SIZE) are in 512-byte sectors. The output columns can be rearranged with the --output
option.
-t, --type type
Specify the partition table type -- aix, bsd, dos, gpt, mac, minix, sgi, solaris_x86, sun, ultrix or unixware.
-n, --nr M:N
Specify the range of partitions. For backward compatibility also the format <M-N> is supported. The range may contain negative
numbers, for example "--nr :-1" means the last partition, and "--nr -2:-1" means the last two partitions. Supported range specifi-
cations are:
<M> Specifies just one partition (e.g. --nr 3).
<M:> Specifies lower limit only (e.g. --nr 2:).
<:N> Specifies upper limit only (e.g. --nr :4).
<M:N> or <M-N> Specifies lower and upper limits (e.g. --nr 2:4).
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 3 /dev/sdb
Prints the start sector of partition 5 on /dev/sda 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>.
AVAILABILITY
The partx command is part of the util-linux package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux/.
1 Feb 2011 PARTX(8)