01-11-2011
Script - columns to rows
Hi Everyone,
I have a file text.cvs, which is a file with columns from excel. The data are separeted with semicolon. The content of the file looks like
A B C D E F
1 3 3 4 3 3
2 2 1 2 5 2
5 6 1 1 2 1
Now I wish to write an script which writes the colums A, C and F in rows like
A 1 2 5
C 3 1 1
F 3 2 1
and save it in a new file newtext.cvs to be viewed in Excel.
Can you help me to write this script?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Friends,
I have a log file as below
siteid = HYD
spc = 100
rset = RS_D_M
siteid = DEL
spc = 200
rset = RS_K_L
siteid = DEL2
spc = 210
rset = RS_D_M
Now I need a output like column wise as below.
siteid SPC rset
HYD 100 RS_D_M (2 Replies)
Discussion started by: suresh3566
2 Replies
2. Shell Programming and Scripting
Hi guys I want to print the values by using this script but its giving the no of rows and columns as input instead of values
Would you plz help me on this
FILE- chr1.txt
1981 1
1971 1
1961 1
1941 1
perl script
#!/usr/bin/perl -w
$infile1 = 'chr1.txt';
$outfile3 = 'out3.txt';
... (3 Replies)
Discussion started by: nogu0001
3 Replies
3. Shell Programming and Scripting
This is for an Oracle journal import. I was using a pl/sql package and oracle API's. Oracle added invoker rights to their API's and now my package won't run. I didn't want to use their API's anyway. The only reason i was using pl/sql and the API's (just a package) was to utilize a cursor. How... (2 Replies)
Discussion started by: lmu
2 Replies
4. Linux
Hi everyone,
how can I convert a file with 3375 rows and 6 columns to a file with
1350 rows and 15 columns
by using a script?
Is it possible with awk or something like that?
Any help is much appreciated.
Thanks.
D. (5 Replies)
Discussion started by: DKalfileritos
5 Replies
5. Shell Programming and Scripting
I have a script which converts rows to columns.
file_name=$1
mailid=$2
#CREATE BACKUP OF ORIGINAL FILE
#cp ${file_name}.xlsx ${file_name}_temp.xlsx
#tr '\t' '|' < ${file_name}_temp.xlsx > ${file_name}_temp.csv
#rm ${file_name}_temp.xlsx
pivot_row=`head -1 ${file_name}`
sed 1d... (3 Replies)
Discussion started by: andy538
3 Replies
6. Shell Programming and Scripting
Hi All
I want to have a Perl script which convert columns to rows.
The Perl should should read the data from input file.
Suppose the input file is
7215484
date to date
173.3
A
1.50
2.23
8.45
10.14
2.00
4.50
2.50
31.32
7216154
month to month (3 Replies)
Discussion started by: parthmittal2007
3 Replies
7. UNIX for Dummies Questions & Answers
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)
Discussion started by: evelibertine
1 Replies
8. Shell Programming and Scripting
Hi
I have a file having the values like below
----------------------------
.set A
col1=”ABC”
col2=34
col3=”DEF”
col4=”LMN”
col5=25
.set A
.set B
col1=55
col3=”XYZ”
col4=”PQR”
col5=66
.set B
.set C
col2=”NNN” (1 Reply)
Discussion started by: Suneel Mekala
1 Replies
9. Shell Programming and Scripting
Hello, everyone
I am beginner for shell programming. I want to print all lines that have the same values in first two columns
data:
a b 1 2
a a 3 4
b b 5 6
a b 4 6
what I expected is :
a a 3 4
b b 5 6
but I searched for one hour in... (2 Replies)
Discussion started by: nengcheng
2 Replies
10. Shell Programming and Scripting
Hello
I have a large database with the following structure:
Headword=Gloss1;Gloss2;Gloss3
The Glosses are separated by a ;
What I need is to reduce the multiple glosses on each row to columns
Headword=Gloss1
Headword=Gloss2
Headword=Gloss3
I had written the following script in awk... (5 Replies)
Discussion started by: gimley
5 Replies
LEARN ABOUT HPUX
cvs-debuild
CVS-DEBUILD(1) General Commands Manual CVS-DEBUILD(1)
NAME
cvs-debuild - build a Debian package using cvs-buildpackage and debuild
SYNOPSIS
cvs-debuild [debuild options] [cvs-buildpackage options] [--lintian-opts lintian options]
DESCRIPTION
cvs-debuild is a wrapper around cvs-buildpackage to run it with debuild as the package-building program. (This cannot simply be accom-
plished using the -C option of cvs-buildpackage, as it does not know how to handle all of the special debuild options.)
The program simply stashes the debuild and lintian options, and passes them to debuild when it is called by cvs-buildpackage. All of the
standard debuild options may be used (as listed below), but note that the root command specified by any --rootcmd or -r command-line option
will be passed as an option to cvs-buildpackage. The first non-debuild option detected will signal the start of the cvs-buildpackage
options.
The selection of the root command is slightly subtle: if there are any command-line options, these will be used. If not, then if cvs-
buildpackage is set up to use a default root command, that will be used. Finally, if neither of these are the case, then debuild will use
its procedures to determine an appropriate command, as described in its documentation.
See the manpages for debuild(1) and cvs-buildpackage for more information about the behaviour of each.
OPTIONS
The following are the debuild options recognised by cvs-debuild. All cvs-buildpackage and lintian options are simply passed to the appro-
priate program. For explanations of the meanings of these variables, see debuild(1).
--no-conf, --noconf
--rootcmd=gain-root-command, -rgain-root-command
--preserve-env
--preserve-envvar=var, -evar
--set-envvar=var=value, -evar=value
--lintian, --no-lintian
--ignore-dirname, --check-dirname
These should not be needed, but it is provided nevertheless.
SEE ALSO
cvs-buildpackage(1), debuild(1), dpkg-buildpackage(1) and lintian(1).
AUTHOR
This program was written by Julian Gilbey <jdg@debian.org>.
DEBIAN
Debian Utilities CVS-DEBUILD(1)