12-21-2010
Anurag,
Thanks for all the support - Now scripts are able to deliver ....Thanks a TON
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Suppose we have 2 set of files
set 1 set 2
------ ------
abc hgb
def ppp
mgh vvv
nmk sdf
hgb ... (1 Reply)
Discussion started by: skyineyes
1 Replies
2. UNIX for Dummies Questions & Answers
Hi, everyone,
Let's say, we have
xxx.txt
A 1 2 3 4 5
C 1 2 3 4 5
E 1 2 3 4 5
yyy.txt
A 1 2 3 4 5
B 1 2 3 4 5
C 1 2 3 4 5
D 1 2 3 4 5
E 1 2 3 4 5
First I match the first column I find intersection (A,C, E), then I want to take those lines with ACE out from yyy.txt, like
A 1... (11 Replies)
Discussion started by: kaixinsjtu
11 Replies
3. Shell Programming and Scripting
Hi! I have a large set of pairs of text files (each pair in their own subdirectory) and each pair shares head/tail (a couple of first and last lines) but differs in the middle part. I need to delete the heads/tails and keep only the middle portions in which they differ. The lengths of heads/tails... (1 Reply)
Discussion started by: dobryden
1 Replies
4. Shell Programming and Scripting
Hi guys,
I have multiple files (>5000) which I have in a folder. I read every file name and put it in a tmp variable "i" so that i can use it in the following task.
I have a large .txt file (>50 MB) in which I want to find the variable "i" and the lines after this variable, so that I can use... (4 Replies)
Discussion started by: Ashitaka007
4 Replies
5. Shell Programming and Scripting
Hi ,
I want to write a simple script.
I have two files
file1:
BCSpeciality
Backend
CB
CBAPQualDisp
CBCimsVFTRCK
CBDSNQualDisp
CBDefault
CBDisney
CBFaxMCGen
CBMCGeneral
CBMCQualDisp
file2:
CSpeciality
Backend (8 Replies)
Discussion started by: ramky79
8 Replies
6. Shell Programming and Scripting
Hi all,
I'd like you to help or give any advise about the following:
I have two (2) files, file1 and file2, both files have information common to each other. The contents of file1 is a subset of the contents of file2:
file1:
errormsgadmin
esdp
esgservices
esignipa
iprice
ipvpn
irm... (0 Replies)
Discussion started by: hnux
0 Replies
7. Shell Programming and Scripting
Hi all,
I'd like you to help or give any advise about the following:
I have two (2) files, file1 and file2, both files have information common to each other. The contents of file1 is a subset of the contents of file2:
file1:
errormsgadmin
esdp
esgservices
esignipa
iprice
ipvpn
irm... (18 Replies)
Discussion started by: hnux
18 Replies
8. Shell Programming and Scripting
Hi All,
I have two files like below:
File1
MYFILE_28012012_1112.txt|4
MYFILE_28012012_1113.txt|51
MYFILE_28012012_1114.txt|57
MYFILE_28012012_1115.txt|57
MYFILE_28012012_1116.txt|57
MYFILE_28012012_1117.txt|57
File2
MYFILE_28012012_1110.txt|57
MYFILE_28012012_1111.txt|57... (2 Replies)
Discussion started by: angshuman
2 Replies
9. UNIX for Dummies Questions & Answers
I've got two files that each contain a 16-digit number in positions 1-16. The first file has 63,120 entries all sorted numerically. The second file has 142,479 entries, also sorted numerically.
I want to read through each file and output the entries that appear in both. So far I've had no... (13 Replies)
Discussion started by: Scottie1954
13 Replies
10. Shell Programming and Scripting
I have two directories
Dir 1
/home/sid/release1
Dir 2
/home/sid/release2
I want to find the common files between the two directories
Dir 1 files
/home/sid/release1>ls -lrt
total 16
-rw-r--r-- 1 sid cool 0 Jun 19 12:53 File123
-rw-r--r-- 1 sid cool 0 Jun 19 12:53... (5 Replies)
Discussion started by: sidnow
5 Replies
LEARN ABOUT DEBIAN
datetime::format::dbi
DateTime::Format::DBI(3pm) User Contributed Perl Documentation DateTime::Format::DBI(3pm)
NAME
DateTime::Format::DBI - Find a parser class for a database connection.
SYNOPSIS
use DBI;
use DateTime;
use DateTime::Format::DBI;
my $db = DBI->connect('dbi:...');
my $db_parser = DateTime::Format::DBI->new($dbh);
my $dt = DateTime->now();
$db->do("UPDATE table SET dt=? WHERE foo='bar'",undef,
$db_parser->format_datetime($dt);
DESCRIPTION
This module finds a "DateTime::Format::*" class that is suitable for the use with a given DBI connection (and "DBD::*" driver).
It currently supports the following format modules: IBM DB2 (DB2), Microsoft SQL (MSSQL), MySQL, Oracle, PostgreSQL (Pg), SQLite, and
Sybase.
NOTE: This module provides a quick method to find the correct parser and formatter class. However, this is usually not sufficient for full
database abstraction. You will also have to cater for differences in the syntax and semantics of SQL datetime functions (and other SQL
commands).
CLASS METHODS
This module provides a single factory method:
o new( $dbh )
Creates a new "DateTime::Format::*" instance, the exact class of which depends on the database driver used for the database connection
referenced by $dbh.
PARSER
/FORMATTER INTERFACE
"DateTime::Format::DBI" is just a front-end class factory that will return one of the format classes based on the nature of your $dbh.
For information on the interface of the returned parser object, please see the documentation for the class pertaining to your particular
$dbh.
In general, parser classes for databases will implement the following methods. For more information on the exact behaviour of these
methods, see the documentation of the parser class.
o parse_datetime( $string )
Given a string containing a date and/or time representation from the database used, this method will return a new "DateTime" object.
If given an improperly formatted string, this method may die.
o format_datetime( $dt )
Given a "DateTime" object, this method returns a string appropriate as input for all or the most common date and date/time types of the
database used.
o parse_duration( $string )
Given a string containing a duration representation from the database used, this method will return a new "DateTime::Duration" object.
If given an improperly formatted string, this method may die.
Not all databases and format/formatter classes support durations; please use UNIVERSAL::has to check for the availability of this
method.
o format_duration( $du )
Given a "DateTime::Duration" object, this method returns a string appropriate as input for the duration or interval type of the
database used.
Not all databases and parser/formatter classes support durations; please use UNIVERSAL::has to check for the availability of this
method.
Parser/formatter classes may additionally define methods like parse_type or format_type (where type is derived from the SQL type); please
see the documentation of the individual format class for more information.
SUPPORT
Please report bugs and other requests to the rt tracker: <https://rt.cpan.org/Public/Dist/Display.html?Name=DateTime-Format-DBI>.
AUTHOR
Claus Faerber <CFAERBER@cpan.org>
LICENSE
Copyright 2003-2010 Claus Faerber. All rights reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
The full text of the license can be found in the LICENSE file included with this module.
SEE ALSO
DateTime, DBI
datetime@perl.org mailing list
http://datetime.perl.org/
perl v5.10.1 2011-02-10 DateTime::Format::DBI(3pm)