04-02-2008
Need help in extracting columns
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
If I could get the required column numbers in a variable in the below format
var_col="1\" \"\$2\" \"\$3"
awk -v awkvar=$var_col '{print $awkvar}'
here I expected to print the 1st,2nd and 3rd cols seprated by a space.But this did not work.
Can somebody help me out here please ?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello!
I wan't to extract columns from two files and later combine them for plotting with gnuplot. If the files file1 and file2 look like:
fiile1:
a, 0.62,x
b, 0.61,x
file2:
a, 0.43,x
b, 0,49,x
The desired output is
a 0.62 0.62
b 0.61 0.49
Thank you in advance! (2 Replies)
Discussion started by: kingkong
2 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
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 ... (14 Replies)
Discussion started by: achak01
14 Replies
4. 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
5. 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
6. Shell Programming and Scripting
Hello,
I have 2 files file1 & file2
=
a1 b1
a2 b2
a3 b3
...
=
c1 d1
c2 d2
c3 d3
...
I need to compare if b(i)=c(j) . i,j=1,2,3,4,...
If yes, right a(i) d(j) in output file3 per line (1 Reply)
Discussion started by: newpromo
1 Replies
7. Shell Programming and Scripting
Hi All,
I have 2 files with a common column.
File 1 looks like
NAME START POS1 POS2
N1 1234 1236 1237
N2 1245 1248 1250
..
..
File 2 looks like
NAME STRING
N1 ABCDEFGH
N2 EFGHBCD
N3 PQRSSTUV
..
......
... (25 Replies)
Discussion started by: alpesh
25 Replies
8. UNIX Desktop Questions & Answers
:wall:Hi there,
I am trying to extract/filter a unique data between specific columns from a tab deliminated file, that has a number of columns:
input file as follow:
5 rs1 70 A C 7 1 1 Blue
5 rs9 66 A E ... (2 Replies)
Discussion started by: houkto
2 Replies
9. Shell Programming and Scripting
Suppose
file1
1
3
8
9
file2
1 2 3 4 5 6 7 8 9 10
1 0 1 0 1 0 1 0 1 0
1 1 1 1 1 0 0 0 0 0
0 0 0 0 0 1 1 1 1 1
I want to print columns listed in file 1 from file2. so the output will look like
1 3 8 9
1 1 0 1 (3 Replies)
Discussion started by: johnkim0806
3 Replies
10. 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
LEARN ABOUT OPENDARWIN
column
COLUMN(1) BSD General Commands Manual COLUMN(1)
NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
DIAGNOSTICS
The column utility exits 0 on success, and >0 if an error occurs.
ENVIRONMENT
COLUMNS The environment variable COLUMNS is used to determine the size of the screen if no other information is available.
EXAMPLES
(printf "PERM LINKS OWNER GROUP SIZE MONTH DAY " ;
printf "HH:MM/YEAR NAME
" ;
ls -l | sed 1d) | column -t
SEE ALSO
colrm(1), ls(1), paste(1), sort(1)
HISTORY
The column command appeared in 4.3BSD-Reno.
BSD
June 6, 1993 BSD