10-04-2012
How are you using awk? Are you running it in a proper shell, or are you using it in windows cmd?
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am trying to merge two large file horizontally using paste command. Every thing is working fine except for time. Its taking lot of time.
Is there any effiecient way of doing the same thing or is there anyway by which I can improve its perfomance programatically?
Thanks,
Yeheya (1 Reply)
Discussion started by: yeheyaansari
1 Replies
2. Shell Programming and Scripting
Hi all,
I have two files -- one with 1024 lines and another with 2048 lines. I want to merge them to create another file in such way that it takes 2 lines from file with 1024 lines and 4 from 2048 lines.
I wrote a sample script and curious to see if there is a better way; i am sure there is,... (4 Replies)
Discussion started by: jakSun8
4 Replies
3. Emergency UNIX and Linux Support
Hi,
I have an input file like
F : 0.1 : 0.002
P : 0.3 : 0.004
P : 0.5 : 0.008
P : 0.1 : 0.005
L : 0.05 : 0.02
P: 0.1 : 0.006
P : 0.01 : 0.08
F : 0.02 : 0.08
Expected output: (2 Replies)
Discussion started by: vasanth.vadalur
2 Replies
4. Programming
Hi
I have a table which has 2 columns - id and amount.
If there duplicate rows , as in id and amount are same , then i have to update the table in such away that only one row should contain amount and all rows should become zero for that id.
eg
id amount
1 100
1 100
2 200
1... (5 Replies)
Discussion started by: megha2525
5 Replies
5. Shell Programming and Scripting
Hi!
Thank you ina advance for your Help. Sorry my english, Im from Argentina!
Great Place!!!
So, here si my problem
I have a variable, lets say PARAMETERS that could be set like this:
PARAMETROS="-Usistemas string1 -Astring2 -G -Y -Kcoco -Y string4 -Z"
or
PARAMETROS="string1... (1 Reply)
Discussion started by: Hercraft
1 Replies
6. Shell Programming and Scripting
<Update>
I have the solution:
sed 's/\{3\}/&;&;---;4/'
The thread can be marked as solved!
</Update>
Hi There,
I'm working on a script processing some data from a website into cvs format. There is only one final problem left I can't find a solution.
I've processed my file... (0 Replies)
Discussion started by: lolworlds
0 Replies
7. UNIX for Dummies Questions & Answers
Hi, I've got a file that I'd like to uniquely sort based on column 2 (values in column 2 begin with "comp").
I tried sort -t -nuk2,3 file.txtBut got:
sort: multi-character tab `-nuk2,3'
"man sort" did not help me out
Any pointers?
Input:
Output: (5 Replies)
Discussion started by: pathunkathunk
5 Replies
8. Shell Programming and Scripting
1.04/1.05:ELA=20000,POLLK=35000,RH=5000,MH=7000,WH=4359
1.7:ELA=2000,POLLK=2000,RH=2000,MH=2000,WH=607
1.9:ELA=2000,POLLK=2000,RH=2000,MH=2000,WH=396
2.0:POLLK=6000,WENS=10000,ELA=7789
I have this above content where in i wan the total of the every row
i.e.
... (9 Replies)
Discussion started by: nikhil jain
9 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I need help!
I have two files, one containing a list of codes and the other a list of codes and their meaning. I need to extract from file 2 all the codes from file 1 into a new file.
These are my files:
File1:
Metbo
Metbo
Memar
Mth
Metbo
File2:
Metbo Methanoculleus... (3 Replies)
Discussion started by: Lokaps
3 Replies
10. Shell Programming and Scripting
Hi,
I have a quick question on parsing the hour/minute and value from a text file and remove the seconds portion. For example in the below text file:
20:26:01 95.83
20:27:01 96.06
20:28:01 95.99
20:29:01 7.11
20:30:01 5.16
20:31:01 8.27
20:32:02 9.79
20:33:01 11.27
20:34:01 7.83... (2 Replies)
Discussion started by: satishrao
2 Replies
LEARN ABOUT DEBIAN
spreadsheet::writeexcel::chart::column
Spreadsheet::WriteExcel::Chart::Column(3pm) User Contributed Perl Documentation Spreadsheet::WriteExcel::Chart::Column(3pm)
NAME
Column - A writer class for Excel Column charts.
SYNOPSIS
To create a simple Excel file with a Column chart using Spreadsheet::WriteExcel:
#!/usr/bin/perl -w
use strict;
use Spreadsheet::WriteExcel;
my $workbook = Spreadsheet::WriteExcel->new( 'chart.xls' );
my $worksheet = $workbook->add_worksheet();
my $chart = $workbook->add_chart( type => 'column' );
# Configure the chart.
$chart->add_series(
categories => '=Sheet1!$A$2:$A$7',
values => '=Sheet1!$B$2:$B$7',
);
# Add the worksheet data the chart refers to.
my $data = [
[ 'Category', 2, 3, 4, 5, 6, 7 ],
[ 'Value', 1, 4, 5, 2, 1, 5 ],
];
$worksheet->write( 'A1', $data );
__END__
DESCRIPTION
This module implements Column charts for Spreadsheet::WriteExcel. The chart object is created via the Workbook "add_chart()" method:
my $chart = $workbook->add_chart( type => 'column' );
Once the object is created it can be configured via the following methods that are common to all chart classes:
$chart->add_series();
$chart->set_x_axis();
$chart->set_y_axis();
$chart->set_title();
These methods are explained in detail in Spreadsheet::WriteExcel::Chart. Class specific methods or settings, if any, are explained below.
Column Chart Methods
There aren't currently any column chart specific methods. See the TODO section of Spreadsheet::WriteExcel::Chart.
EXAMPLE
Here is a complete example that demonstrates most of the available features when creating a chart.
#!/usr/bin/perl -w
use strict;
use Spreadsheet::WriteExcel;
my $workbook = Spreadsheet::WriteExcel->new( 'chart_column.xls' );
my $worksheet = $workbook->add_worksheet();
my $bold = $workbook->add_format( bold => 1 );
# Add the worksheet data that the charts will refer to.
my $headings = [ 'Number', 'Sample 1', 'Sample 2' ];
my $data = [
[ 2, 3, 4, 5, 6, 7 ],
[ 1, 4, 5, 2, 1, 5 ],
[ 3, 6, 7, 5, 4, 3 ],
];
$worksheet->write( 'A1', $headings, $bold );
$worksheet->write( 'A2', $data );
# Create a new chart object. In this case an embedded chart.
my $chart = $workbook->add_chart( type => 'column', embedded => 1 );
# Configure the first series. (Sample 1)
$chart->add_series(
name => 'Sample 1',
categories => '=Sheet1!$A$2:$A$7',
values => '=Sheet1!$B$2:$B$7',
);
# Configure the second series. (Sample 2)
$chart->add_series(
name => 'Sample 2',
categories => '=Sheet1!$A$2:$A$7',
values => '=Sheet1!$C$2:$C$7',
);
# Add a chart title and some axis labels.
$chart->set_title ( name => 'Results of sample analysis' );
$chart->set_x_axis( name => 'Test number' );
$chart->set_y_axis( name => 'Sample length (cm)' );
# Insert the chart into the worksheet (with an offset).
$worksheet->insert_chart( 'D2', $chart, 25, 10 );
__END__
AUTHOR
John McNamara jmcnamara@cpan.org
COPYRIGHT
Copyright MM-MMX, John McNamara.
All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.
perl v5.10.1 2010-02-02 Spreadsheet::WriteExcel::Chart::Column(3pm)