11-04-2014
Yes good point Aia - print statement in the code above may need to change to print L[1] above if the OP is after the "Database alias" line.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
All,
Is there any way out to display the nth line before the string is matched ???
Eg : If i have a file which has the following contents and if i want to get the
3rd line before the string is matched
a
b
c
d
e
f
if i give the input as f and lines before the match as 3 then it should... (5 Replies)
Discussion started by: helper
5 Replies
2. Shell Programming and Scripting
Hi,
I have many scripts in particular directory. And few of the scripts have exit 0 in second line. Now i wanted to list out the scripts name which has the exit 0 in its second line
I tried many options , but i can not get the filename along with the nth line pattern match :mad:. Can anyone... (14 Replies)
Discussion started by: puni
14 Replies
3. Shell Programming and Scripting
Hi,
I am looking for any script which can do the following.
have to read a pattern from fileA and copy it to fileB.
fileA:
...
...
Header
...
...
..p1
...
...
fileB:
....
....
Header (3 Replies)
Discussion started by: anilvk
3 Replies
4. UNIX for Dummies Questions & Answers
Hi ,
I want to print the nth and n+1 lines from a file once it gets a pattern match.
For eg:
aaa
bbb
ccc
ddd
gh
jjjj
If I find a match for bbb then I need to print bbb as well as 3rd and 4th line from the match.. Please help..Is it possible to get a command using sed :) (6 Replies)
Discussion started by: saj
6 Replies
5. Shell Programming and Scripting
Hi,
I am getting crazy after days on looking at it:
Bash in Ubuntu 12.04.1
I want to do this:
pattern="system /path1/file1 file1"
new_pattern=" data /path2/file2 file2"
file to edit: data.db
- I need to search in the file data.db for the nth occurrence of pattern
- pattern must... (14 Replies)
Discussion started by: Phil3759
14 Replies
6. Shell Programming and Scripting
Hi,
I have below file, each line that starts with /* marks the beginning of the a new job.
/* ----------------- cmdsMlyMoveTPMPLANTJ -----------------
UNIX_JOB CMMM002J
CMDNAME /home2/proddata/bin/moveTPMPLANT.sh
AGENT CMDSHP
USER proddata
AFTER CMMU001J
/* "DDRG monthly... (13 Replies)
Discussion started by: varun22486
13 Replies
7. Shell Programming and Scripting
Im using the command below , but thats not the output that i want. it only prints the odd and even numbers.
awk '{if(NR%2){print $0 > "1"}else{print $0 > "2"}}'
Im hoping for something like this
file1:
Text hi this is just a test
text1 text2 text3 text4 text5 text6
Text hi... (2 Replies)
Discussion started by: invinzin21
2 Replies
8. Shell Programming and Scripting
Hello Experts , require help . See below output:
File inputs
------------------------------------------
Server Host = mike
id rl images allocated last updated density
vimages expiration last read <------- STATUS ------->... (4 Replies)
Discussion started by: tigerhills
4 Replies
9. Shell Programming and Scripting
I am trying to combine lines with these conditions:
1. First line starts with text of "libname VALUE db2 datasrc" where VALUE can be any text.
2. If condition1 is met then continue to combine lines through a line that ends with a semicolon.
3. Ignore case when matching patterns and remove any... (5 Replies)
Discussion started by: Wes Kem
5 Replies
10. AIX
Please help me
print nth line after match
awk or sed one line command. (3 Replies)
Discussion started by: sushma123
3 Replies
LEARN ABOUT DEBIAN
test::database::handle
Test::Database::Handle(3pm) User Contributed Perl Documentation Test::Database::Handle(3pm)
NAME
Test::Database::Handle - A class for Test::Database handles
SYNOPSIS
use Test::Database;
my $handle = Test::Database->handle(@requests);
my $dbh = $handle->dbh();
DESCRIPTION
"Test::Database::Handle" is a very simple class for encapsulating the information about a test database handle.
"Test::Database::Handle" objects are used within a test script to obtain the necessary information about a test database handle. Handles
are obtained through the "Test::Database->handles()" or "Test::Database->handle()" methods.
METHODS
"Test::Database::Handle" provides the following methods:
new( %args )
Return a new "Test::Database::Handle" with the given parameters ("dsn", "username", "password").
The only mandatory argument is "dsn".
The following accessors are available.
dsn()
Return the Data Source Name.
username()
Return the connection username.
password()
Return the connection password.
connection_info()
Return the connection information triplet ("dsn", "username", "password").
dbh( [ $attr ] )
Return the DBI database handle obtained when connecting with the connection triplet returned by "connection_info()".
The optional parameter $attr is a reference to a hash of connection attributes, passed directly to DBI's "connect()" method.
name()
Return the database name attached to the handle.
dbd()
Return the DBI driver name, as computed from the "dsn".
driver()
Return the "Test::Database::Driver" object attached to the handle.
AUTHOR
Philippe Bruhat (BooK), "<book@cpan.org>"
COPYRIGHT
Copyright 2008-2010 Philippe Bruhat (BooK), all rights reserved.
LICENSE
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.10.1 2010-11-27 Test::Database::Handle(3pm)