12-09-2012
The script provided by bipinajith works well. But there could be many date above each request type in which i need to pick the date immediately before the Request type string. i have highlighted the dates in bold. we cannot seach with date and time since it will be changed month on month. Could you please suggest me to get this date?.
HTML Code:
Cat test
Nov 10, 2012 5:12:53 AM
Nov 10, 2012 5:13:53 AM
[B]Nov 10, 2012 5:17:53 AM[/B]
INFO: Request Type
Line 1. <fullOperation>MAKE:NUMBER:9366109380:PPAY2;</fullOperation>
Line 2. <starttime>20081003000047</starttime>
Line 3. <stoptime>20081003000047</stoptime>
Line 4. <fullResult>940120105;;</fullResult>
Line 5. <status>FAILED</status>
Nov 10, 2012 5:18:53 AM
Nov 10, 2012 5:19:53 AM
[B]Nov 10, 2012 5:20:53 AM[/B]
WARNING: Request Method
Line 1. <fullOperation>MAKE:NUMBER:5424683284:PPAY2;</fullOperation>
Line 2. <starttime>20081003000047</starttime>
Line 3. <stoptime>20081003000047</stoptime>
Line 4. <fullResult>940120105;;</fullResult>
Line 5. <status>FAILED</status>
Nov 10, 2012 5:22:53 AM
Nov 10, 2012 5:23:53 AM
[B]Nov 10, 2012 5:25:53 AM[/B]
FATAL: Response Type
Line 1. <fullOperation>MAKE:NUMBER:5424678435:PPAY2;</fullOperation>
Line 2. <starttime>20081003000047</starttime>
Line 3. <stoptime>20081003000047</stoptime>
Line 4. <fullResult>940120105;;</fullResult>
Line 5. <status>FAILED</status>
Result
---------
Nov 10, 2012 5:17:53 AM,INFO,Request Type,MAKE:NUMBER:9366109380:PPAY2;,20081003000047,20081003000047,940120105;;,FAILED
Nov 10, 2012 5:20:53 AM,WARNING,Request Method,MAKE:NUMBER:5424683284:PPAY2;,20081003000047,20081003000047,940120105;;,FAILED
Nov 10, 2012 5:25:53 AM,FATAL,Response Type,MAKE:NUMBER:5424678435:PPAY2;,20081003000047,20081003000047,940120105;;,FAILED
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I have a file that I need to be able to find a pattern match on a line, search that line for a text pattern, and replace that text.
An example of 4 lines in my file is:
1. MatchText_randomNumberOfText moreData ReplaceMe moreData
2. MatchText_randomNumberOfText moreData moreData... (4 Replies)
Discussion started by: Crypto
4 Replies
2. Shell Programming and Scripting
I want to know wich hdisk have only one pvid and also display hdisk with two pvid.
hdisk1 00c3fcd4e516183f testvg active
hdisk2 00c3fcd4e516189b testvg active
hdisk3 00c3fcd4e51618ec testvg ... (1 Reply)
Discussion started by: khalidou13
1 Replies
3. Shell Programming and Scripting
I 've got this retourn when i tape the commande lspv:
hdisk0 00c3fce454950416 rootvg active
hdisk1 00c3fce454950416 rootvg active
I want to verify if hdisk0 et hdisk1 have the same pvid (ex : 00c3fce454950416)?
Can... (8 Replies)
Discussion started by: khalidou13
8 Replies
4. Shell Programming and Scripting
I have multiple config files where I need to pull the ip address from loopback3. The format is the same in every file, the ip is the second line after interface loopback3.
interface loopback2 loopback
description router ID
ip address 192.168.1.1
interface loopback3 loopback
description... (3 Replies)
Discussion started by: numele
3 Replies
5. Shell Programming and Scripting
Hi Guys,
I am trying to write a perl script to search a string "Name" in the file "FILE" and also want to create a new file and push the searched string Name line along with 10 lines following the same.
can anyone of you please let me know how to go about it ? (8 Replies)
Discussion started by: sukrish
8 Replies
6. Shell Programming and Scripting
I am having a text file which is having more than 200 lines.
EX:
001010122 12000 BIB 12000 11200 1200003
001010122 2000 AND 12000 11200 1200003
001010122 12000 KVB 12000 11200 1200003
In the above file i want to search for string KVB and add/replace... (1 Reply)
Discussion started by: suryanarayana
1 Replies
7. Shell Programming and Scripting
Dear All
I am having a text file which is having more than 200 lines.
EX:
001010122 12000 BIB 12000 11200 1200003
001010122 2000 AND 12000 11200 1200003
001010122 12000 KVB 12000 11200 1200003
In the above file i want to search for string KVB... (5 Replies)
Discussion started by: suryanarayana
5 Replies
8. Shell Programming and Scripting
Hi,
Need your help for this scripting issue I have. I am not really good at this, so seeking your help.
I have a file looking similar to this:
Hello, i am human and name=ABCD.
How are you?
Hello, i am human and name=PQRS.
I am good.
Hello, i am human and name=ABCD.
Good bye.
Hello, i... (12 Replies)
Discussion started by: royzlife
12 Replies
9. UNIX for Advanced & Expert Users
I must have forgot how to do this, but, I am attempting to enter a variable into an awk / gawk search pattern.
I am getting a value from user input to place in a specific section of a 132 character string.
my default command is ....
gawk --re-interval '/^(.{3}P .{4}CYA.{8}1)/' ... (3 Replies)
Discussion started by: sdeevers
3 Replies
10. UNIX for Dummies Questions & Answers
Hi Everyone,
I have a requirement in ksh where i have a set of files in a directory. I need to search each and every file if a particular string is present in the file, delete that line and replace that line with another string expression in the same file.
I am very new to unix. Kindly help... (10 Replies)
Discussion started by: Pradhikshan
10 Replies
LEARN ABOUT DEBIAN
excel::writer::xlsx::chart::line
Excel::Writer::XLSX::Chart::Line(3pm) User Contributed Perl Documentation Excel::Writer::XLSX::Chart::Line(3pm)
NAME
Line - A class for writing Excel Line charts.
SYNOPSIS
To create a simple Excel file with a Line chart using Excel::Writer::XLSX:
#!/usr/bin/perl
use strict;
use warnings;
use Excel::Writer::XLSX;
my $workbook = Excel::Writer::XLSX->new( 'chart.xlsx' );
my $worksheet = $workbook->add_worksheet();
my $chart = $workbook->add_chart( type => 'line' );
# 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 Line charts for Excel::Writer::XLSX. The chart object is created via the Workbook "add_chart()" method:
my $chart = $workbook->add_chart( type => 'line' );
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 Excel::Writer::XLSX::Chart. Class specific methods or settings, if any, are explained below.
Line Chart Methods
There aren't currently any line chart specific methods. See the TODO section of Excel::Writer::XLSX::Chart.
EXAMPLE
Here is a complete example that demonstrates most of the available features when creating a chart.
#!/usr/bin/perl
use strict;
use warnings;
use Excel::Writer::XLSX;
my $workbook = Excel::Writer::XLSX->new( 'chart_line.xlsx' );
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', 'Batch 1', 'Batch 2' ];
my $data = [
[ 2, 3, 4, 5, 6, 7 ],
[ 10, 40, 50, 20, 10, 50 ],
[ 30, 60, 70, 50, 40, 30 ],
];
$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 => 'line', embedded => 1 );
# Configure the first series.
$chart->add_series(
name => '=Sheet1!$B$1',
categories => '=Sheet1!$A$2:$A$7',
values => '=Sheet1!$B$2:$B$7',
);
# Configure second series. Note alternative use of array ref to define
# ranges: [ $sheetname, $row_start, $row_end, $col_start, $col_end ].
$chart->add_series(
name => '=Sheet1!$C$1',
categories => [ 'Sheet1', 1, 6, 0, 0 ],
values => [ 'Sheet1', 1, 6, 2, 2 ],
);
# 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 (mm)' );
# Set an Excel chart style. Colors with white outline and shadow.
$chart->set_style( 10 );
# 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-MMXII, 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 2012-04-02 Excel::Writer::XLSX::Chart::Line(3pm)