For the duration you need complex date/time arithmetics to take into account e.g. durations crossing midnight. There's quite some threads on this available, pls. search this forum.
However, try this:
Hi all
Is there a way in awk to know that you are processing your final line of input if you do no know how many lines were in the input to begin with?
Thanks (7 Replies)
Hi Very much appreciate if somebody could give me a clue ..
I undestand that it could be done with awk but have a limited experience.
I have the following text in the file
1 909 YES NO
2 500 No NO
.
...
1 ... (8 Replies)
Input File:
1234, 2345,abc
1,24141,gw
222,rff,sds
2232145,sdsd,121
Output file to be generated:
000001234,2345,abc
000000001,24141,gw
000000222,rff,sds
002232145,sdsd,121
i.e; the first column is padded to get 9 digits.
I tried with following: (3 Replies)
I have many lines like the following in a file(there are also other kinds of lines)
Host: 72.52.104.74 (tserv1.fmt2.he.net) Ports: 22/open/tcp//tcpwrapped///, 53/open/tcp//domain//PowerDNS 3.3/, 179/open/tcp//tcpwrapped/// Ignored State: closed (997) Seq Index: 207 IP ID Seq: All... (9 Replies)
Hello,
I extracted a list of files in a directory with the command ls . However this is not my computer, so the ls functionality has been revamped so that it gives the filesizes in front like this :
This is the output of ls command : I stored the output in a file filelist
1.1M... (5 Replies)
I dispose of two tab-delimited files (the first column is the primary key):
File 1 (there are multiple rows sharing the same key, I cannot merge them)
A 28,29,30,31
A 17,18,19
B 11,13,14,15
B 8,9File 2 (there is one only row beginning with a given key)
A 2,8,18,30,31
B ... (3 Replies)
hello All, I'm new to AWK programming and learned myself few things to process a file and deal with duplicate lines, but I got into a scenario which makes me clueless to handle. Here is the scenario..
Input file:
user role
----- ----
AAA add
AAA delete
BBB delete
CCC delete
DDD ... (10 Replies)
Hi,my file is in this format
",
\"symbol\": \"Rbm38\"
} ]"
I want to convert it to a more user readable format
_id pubmed text symbol
67196 18667844 Overexpression of UBE2T in NIH3T3 cells significantly promoted colony formation in mouse cell cultures Ube2t
56190 21764855 ... (3 Replies)
Discussion started by: biofreek
3 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)