|
|
Sponsored Content
Operating Systems
Linux
help with columns and rows - script
Post 302531353 by DKalfileritos on Thursday 16th of June 2011 01:11:34 PM
06-16-2011
thanks
Thanks everyone for replying so quickly!
I think yazu's answer is very close, however the script "skips" always the value "-9999.0" which I would like to keep, and does not "keep" the 15th value. Corona88 actually made exactly what I wanted to do.
Thank you all guys for your help!!!
D.
I think yazu's answer is very close, however the script "skips" always the value "-9999.0" which I would like to keep, and does not "keep" the 15th value. Corona88 actually made exactly what I wanted to do.
Thank you all guys for your help!!!
D.
|
|
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. Shell Programming and Scripting
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... (4 Replies)
Discussion started by: Tob26
4 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 DEBIAN
chronicle-spooler
CHRONICLE-SPOOLER(1) User Contributed Perl Documentation CHRONICLE-SPOOLER(1) NAME
chronicle-spooler - Automatically post pre-written entries. SYNOPSIS
Path Options: --config Specify a configuration file to read. --spool-dir Specify where pending entries are located. --live-dir Specify where the entries should be moved to. Post-Spool Commands: --post-move Specify a command to execute once entries have been moved. Optional Features: --test Only report on what would be executed. Help Options: --help Show the help information for this script. --manual Read the manual for this script. ABOUT
chronicle-spooler is a companion scrip to the chronicle blog compiler. It is designed to facilitate posting new entries automatically upon particular dates. (ie. If you have ten written blog entries in a spool directory it will move them into place upon the date you've specified.) DATE SPECIFICATION
To specify the date a particular entry should be made live you must add another pseudo-header to your blog entry files, as follows: Title: This is the title of the blog post Date: 2nd March 2007 Publish: 15th April 2008 Tags: one, two, three, long tag The text of your entry goes here. In this example we know that this entry will be made live upon the 15th April 2008, and not before. AUTHOR
Steve -- http://www.steve.org.uk/ LICENSE
Copyright (c) 2008-2010 by Steve Kemp. All rights reserved. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The LICENSE file contains the full text of the license. perl v5.12.3 2011-05-03 CHRONICLE-SPOOLER(1)