How to print previous line of multiple pattern matched line?
Hello,
I have below format log file,
I wanted to print line starting with ^Line and having diff value greater than > 10.000
Along with it previous line starting with ^Comapring string. So basically a line starting with ^Comparing can have multiple corresponding line starting with ^Line.
grep -B1 gives previous line only if single line having ^Line is present but however with multiple lines having ^Line doesn't work.
Any help appreciated and let me know if any further information is required.
Thanks,
Arvind.
Last edited by Don Cragun; 02-04-2016 at 04:53 AM..
Reason: Get rid of Italic and COLOR tags; add CODE and ICODE tags.
I have the following text format in a file which lists the question first and then 5 choices
after that the explanantion and finally the answer.
1.The amount of time it takes for most of a worker’s occupational knowledge and skills to become
obsolete has been declining because of the... (2 Replies)
Hi Experts,
Help needed on joining one line above & below to the pattern matched string line.
The input file, required output is mentioned below
Input file
ABCD DEFG5 42.0.1-63.38.31
KKKK iokl IP Connection Available
ABCD DEFG5 42.0.1-63.38.31
... (7 Replies)
Hello,
I'm new to this forum. I've been doing a lot of sed work lately and have found many useful tips on this forum. I've hit a roadblock in a project, though, and could really use some help.
I have a text file with many lines like the following, i.e., some lines begin with a single word... (3 Replies)
Hi all,
on Solaris 10, I'd like to print a range of lines starting at pattern but also including the very first line before pattern.
the following doesn't print the range starting at pattern and going down to the end of file: cat <my file> | sed -n -e '/<pattern>{x;p;}/'
I need to include the... (1 Reply)
Hi all,
I have a text data file. My aim here is to find line called *FIELD* AV for every record and print lines after that till *FIELD* RF. But here I want first 3 to four lines for very record as well. FIELD AV is some where in between for very record. SO I am not sure how to retrieve lines in... (2 Replies)
Hello Friends,
I need to print lines in between two string when a keyword existed in those lines (keywords like exception, error, failed, not started etc).
for example,
input:
..
Begin Edr
ab12
ac13
ad14
bc23
exception occured
bd24
cd34
dd44
ee55
ff66
End Edr (2 Replies)
Hi experts,
I have a file with regexes which is used for automatic searches on several files (40+ GB).
To do some postprocessing with the grep result I need the matching line as well as the match itself.
I know that the latter could be achieved with grep's -o option. But I'm not aware of a... (2 Replies)
hello everyone,
im new here, and also programming with awk, sed and grep commands on linux.
In my text i have many lines with this config:
1 1 4 3 1 1 2 5
2 2 1 1 1 3 1 2
1 3 1 1 1 2 2 2
5 2 4 1
3 2 1 1 4 1 2 1
1 1 3 2 1 1 5 4
1 3 1 1... (3 Replies)
Hi I want to print the line until pattern is matched.
I am using below code:
sed -n '1,/pattern / p' file
It is working fine for me , but its not working for exact match.
sed -n '1,/^LAC$/ p' file
Input:
LACC FEGHRA 0
LACC FACAF 0
LACC DARA 0
LACC TALAC 0
LAC ILACTC 0... (8 Replies)
Discussion started by: Abhisrajput
8 Replies
LEARN ABOUT DEBIAN
class::csv
CSV(3pm) User Contributed Perl Documentation CSV(3pm)NAME
Class::CSV - Class based CSV parser/writer
SYNOPSIS
use Class::CSV;
my $csv = Class::CSV->parse(
filename => 'test.csv',
fields => [qw/item qty sub_total/]
);
foreach my $line (@{$csv->lines()}) {
$line->sub_total('$'. sprintf("%0.2f", $line->sub_total()));
print 'Item: '. $line->item(). "
".
'Qty: '. $line->qty(). "
".
'SubTotal: '. $line->sub_total(). "
";
}
my $cvs_as_string = $csv->string();
$csv->print();
my $csv = Class::CSV->new(
fields => [qw/userid username/],
line_separator => "
";
);
$csv->add_line([2063, 'testuser']);
$csv->add_line({
userid => 2064,
username => 'testuser2'
});
DESCRIPTION
This module can be used to create objects from CSV files, or to create CSV files from objects. Text::CSV_XS is used for parsing and
creating CSV file lines, so any limitations in Text::CSV_XS will of course be inherant in this module.
EXPORT
None by default.
METHOD
CONSTRUCTOR
parse
the parse constructor takes a hash as its paramater, the various options that can be in this hash are detailed below.
Required Options
o fields - an array ref containing the list of field names to use for each row. there are some reserved words that cannot be
used as field names, there is no checking done for this at the moment but it is something to be aware of. the reserved field
names are as follows: "string", "set", "get". also field names cannot contain whitespace or any characters that would not be
allowed in a method name.
Source Options (only one of these is needed)
o filename - the path of the CSV file to be opened and parsed.
o filehandle - the file handle of the CSV file to be parsed.
o objects - an array ref of objects (e.g. Class::DBI objects). for this to work properly the field names provided in fields needs
to correspond to the field names of the objects in the array ref.
o classdbi_objects - depreciated use objects instead - using classdbi_objects will still work but its advisable to update your
code.
Optional Options
o line_separator - the line seperator to be included at the end of every line. defaulting to "
" (unix carriage return).
new the new constructor takes a hash as its paramater, the same options detailed in parse apply to new however no Source Options can be
used. this constructor creates a blank CSV object of which lines can be added via add_line.
ACCESSING
lines
returns an array ref containing objects of each CSV line (made via Class::Accessor). the field names given upon construction are
available as accessors and can be set or get. for more information please see the notes below or the perldoc for Class::Accessor. the
lines accessor is also able to be updated/retrieved in the same way as individual lines fields (examples below).
Example
retrieving the lines:
my @lines = @{$csv->lines()};
removing the first line:
pop @lines;
$csv->lines(@lines);
sorting the lines:
@lines = sort { $a->userid() <=> $b->userid() } @lines:
$csv->lines(@lines);
sorting the lines (all-in-one way):
$csv->lines([ sort { $a->userid() <=> $b->userid() } @{$csv->lines()} ]);
Retrieving a fields value
there is two ways to retrieve a fields value (as documented in Class::Accessor). firstly you can call the field name on the object
and secondly you can call "get" on the object with the field name as the argument (multiple field names can be specified to
retrieve an array of values). examples are below.
my $value = $line->test();
OR
my $value = $line->get('test');
OR
my @values = $line->get(qw/test test2 test3/);
Setting a fields value
setting a fields value is simmilar to getting a fields value. there are two ways to set a fields value (as documented in
Class::Accessor). firstly you can simply call the field name on the object with the value as the argument or secondly you can call
"set" on the object with a hash of fields and their values to set (this isn't standard in Class::Accessor, i have overloaded the
"set" method to allow this). examples are below.
$line->test('123');
OR
$line->set( test => '123' );
OR
$line->set(
test => '123',
test2 => '456'
);
Retrieving a line as a string
to retrieve a line as a string simply call "string" on the object.
my $string = $line->string();
new_line
returns a new line object, this can be useful for to "splice" a line into lines (see example below). you can pass the values of the
line as an ARRAY ref or a HASH ref.
Example
my $line = $csv->new_line({ userid => 123, domainname => 'splicey.com' });
my @lines = $csv->lines();
splice(@lines, 1, 0, $line);
OR
splice(@{$csv->lines()}, 1, 0, $csv->new_line({ userid => 123, domainname => 'splicey.com' }));
add_line
adds a line to the lines stack. this is mainly useful when the new constructor is used but can of course be used with any constructor.
it will add a new line to the end of the lines stack. you can pass the values of the line as an ARRAY ref or a HASH ref. examples of
how to use this are below.
Example
$csv->add_line(['house', 100000, 4]);
$csv->add_line({
item => 'house',
cost => 100000,
bedrooms => 4
});
OUTPUT
string
returns the object as a string (CSV file format).
print
calls "print" on string (prints the CSV to STDOUT).
SEE ALSO
Text::CSV_XS, Class::Accessor
AUTHOR
David Radunz, <david@boxen.net>
COPYRIGHT AND LICENSE
Copyright 2004 by David Radunz
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.10.0 2007-02-08 CSV(3pm)