04-24-2006
Date Reformat
Hello,
I have a .CSV file with 10+ datetime columns. The way the data is stored
in these columns are -
4/4/2006 3:45:30 PM
I want the single digits to be left padded with a zero so the above looks like
04/04/2006 03:45:30 PM
As the dates and times are different throughout the file manually changing
it in the file with a find and replace is not considered.
Any function/command to achieve this will be appreciated. Thanks.
Rgds,
F1
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I ran into this problem, hope you can help
I have a text file like this:
Spriden ID First Name Last Name Term Code Detail Code Amount Trans Date Description ... (3 Replies)
Discussion started by: CamTu
3 Replies
2. Solaris
hi
i need help on how to reformat a hard disk. what should i do since i don't have any bootable disk. i'm using solaris 1 & 2 and also need to make a backup copy of the current hard disk. appreciate all the help i can get... (14 Replies)
Discussion started by: mr_balodoy
14 Replies
3. Shell Programming and Scripting
I am trying to write an awk program to reformat a data table and convert the date to julian time. I have all the individual steps working, but I am having some issues joing them into one program. Can anyone help me out? Here is my code so far:
# This is an awk program to convert the dates from... (4 Replies)
Discussion started by: climbak
4 Replies
4. Shell Programming and Scripting
The command below is getting me the output I need.
awk -F"," ' {
if ($6 = 475) print "@@"$3 " " "0000" $10 "0" $1 "00000000" $8}' ${DIR1}${TMPFILE1} | sed -e 's/@@1//g' > ${DIR2}${TPRFILE}
Output:
900018732 00004961160200805160000000073719
Now I need to incorporate... (5 Replies)
Discussion started by: mondrar
5 Replies
5. UNIX for Advanced & Expert Users
I often use "ps -ef" command to list all running processes. Now i want to customize the output to show only 2 parts: CMD and UID as below:
/bin/bash /usr/bin/run-parts /etc/cron.weekly root
/usr/sbin/httpd apache
/usr/sbin/httpd apache
/usr/sbin/httpd apache
I use ps -ef | awk '{print $8"... (3 Replies)
Discussion started by: fongthai
3 Replies
6. Shell Programming and Scripting
I am working with a file of the form;
4256 7726 1
6525 716 1
7626 0838 1
8726 7623 2
8625 1563 2
1662 2628 3
1551 3552 3
1542 7984 ... (3 Replies)
Discussion started by: digipak
3 Replies
7. Shell Programming and Scripting
I would like to determine if a file is older than a particular date. I found that istat will let me see the date and time of a file older than a year, but I need to change the format. Could anyone help me reformat the following date to a variable (a one liner would be great).
Output from istat -... (1 Reply)
Discussion started by: oldman2
1 Replies
8. Shell Programming and Scripting
I have a csv file with 11 columns. The first columns contains the User Id. One User id can have multiple sub Id.
The value of Sub Id is in column 10.
100026,captjason@hawaii.rr.com ,jason ,wolford ,1/16/1969, ,US, ,96761 ,15 ,seg_id
100026,captjason@hawaii.rr.com ,jason ,wolford ,1/16/1969,... (3 Replies)
Discussion started by: r_t_1601
3 Replies
9. Shell Programming and Scripting
Hello, I have many lengthy files that need to be reformatted. I was hoping a sed or awk script could fix this.
Here is an example of the original format:
P0037
# Degree: 32.999981
# COMMAND: 03 (#01A) Scale 1.296875, 52 (Wooden Crate w/ #2 Label, Bahko)
v -3328.000000 12.101541 437.000000... (2 Replies)
Discussion started by: Blue Solo
2 Replies
10. Shell Programming and Scripting
Trying to parse column C ($3) of the attached file (104 rows). The data is in the below format all in a string. Each string would be a separate row with the data in column A ($1) and column B ($2) being the header. All the data is in seperate columns as well. Thank you :).
ACTA 59... (9 Replies)
Discussion started by: cmccabe
9 Replies
LEARN ABOUT DEBIAN
datetime::format::db2
DateTime::Format::DB2(3pm) User Contributed Perl Documentation DateTime::Format::DB2(3pm)
NAME
DateTime::Format::DB2 - Parse and format DB2 dates and times
SYNOPSIS
use DateTime::Format::DB2;
my $dt = DateTime::Format::DB2->parse_timestamp( '2003-01-16-23.12.01.300000' );
# 2003-01-16-23.12.01.300000
DateTime::Format::DB2->format_timestamp($dt);
DESCRIPTION
This module understands the formats used by DB2 for its DATE, TIME, and TIMESTAMP data types. It can be used to parse these formats in
order to create DateTime objects, and it can take a DateTime object and produce a string representing it in the DB2 format.
METHODS
This class offers the following methods. All of the parsing methods set the returned DateTime object's time zone to the floating time
zone, because DB2 does not provide time zone information.
* parse_time($string)
* parse_date($string)
* parse_timestamp($string)
Given a value of the appropriate type, this method will return a new "DateTime" object. The time zone for this object will always be
the floating time zone, because by DB2 stores the local datetime, not UTC.
If given an improperly formatted string, this method may die.
* format_date($datetime)
* format_time($datetime)
* format_timestamp($datetime)
Given a "DateTime" object, this methods returns an appropriately formatted string.
SUPPORT
Support for this module is provided via the datetime@perl.org email list. See http://lists.perl.org/ for more details.
AUTHOR
Jess Robinson <castaway@desert-island.demon.co.uk>
This module was shamelessly cloned from Dave Rolsky's DateTime::Format::MySQL module.
COPYRIGHT
Copyright (c) 2005 Jess Robinson. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
SEE ALSO
datetime@perl.org mailing list
http://datetime.perl.org/
perl v5.8.8 2007-01-20 DateTime::Format::DB2(3pm)