07-18-2011
Extract date from filename and set timestamp
I have lots of files in this format:
dvgrab-2003.06.29_15-30-24.mpg
The numbers represents the date and time (YYYY.MM.DD_HH-MM-SS)
How can I extract the dates from the filenames, and use the dates in the file timestamp?
I guess this can be done by using "find", "sed" and "touch"?
Can anyone help, please?
BR,
Q
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
i want to replace the previous time stamp with the current timsatp at the start of the file like
20090710_113354_FT0710a.txt this one to 20091111__113354_FT0710a.txt
thanks in advance (3 Replies)
Discussion started by: Reddy482
3 Replies
2. Shell Programming and Scripting
Hi.,
My file name is of the format:
name_abc_20100531_142528.txt
where.,
my timestamp is of the format:
yyyymmdd_hhmmss
How to extract the date strring and time string into seperate variables in the shell script, after reading the file as the input?
I want to get the variables... (9 Replies)
Discussion started by: av_vinay
9 Replies
3. Shell Programming and Scripting
Hi, i have a filename CRED20102009.txt in a server
20102009 is the date of the file ddmmaaaa format
the complete route is
/dprod/informatica/Fuentes/CRED20102009.csv
i want to extract the date to create a new file named Parameters.txt
I need to create Parameters.txt with this... (6 Replies)
Discussion started by: angel1001
6 Replies
4. Shell Programming and Scripting
Hi,
In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date×tamp. I have to figure out the the data is a date or time stamp or date×tamp.
If it is date then append "<space>00:00:00"... (1 Reply)
Discussion started by: machomaddy
1 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
Thanks in Advance
I am working on a shell script. I need some assistance.
My Requirement:
1) There are some set of files in a directory like given below
OTP_UFSC_20120530000000_acc.csv
OTP_UFSC_20120530000000_faf.csv
OTP_UFSC_20120530000000_prom.csv... (0 Replies)
Discussion started by: aealexanderraj
0 Replies
6. Programming
Hi All,
Thanks in Advance
I am working on a shell script. I need some assistance.
My code:
if
then
set "subscriber" "promplan" "mapping" "dedicatedaccount" "faflistSub" "faflistAcc" "accumulator"\
"pam_account";
for i in 1 2 3 4 5 6 7 8;... (0 Replies)
Discussion started by: aealexanderraj
0 Replies
7. Shell Programming and Scripting
Hi Gurus,
I have different files with different timestamp and different base file name, I have to group those files based on basename and provide a unique file name for similar file names.
My Directory has following files.
abc_filename_20130623:00:09:00.txt... (1 Reply)
Discussion started by: user_linux
1 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
I have incoming source files abcmmyy.txt I need to extract the mmyy part from the filename and pass that to a variable . I really appreciate your quick response on this.
Thanks
raj (7 Replies)
Discussion started by: rajeevm
7 Replies
9. UNIX for Beginners Questions & Answers
Hi,
I'm totally new in sell script and working with a shell code. I want to extract the date and time from the filenames. The filenames are different but all of them begins with WI_ SCOPE_:
WI_SCOPE_DATA_CHANGE_2017-09-12_15-30-40.txt
WI_SCOPE_BACK_COMPLETE_QUEUE_2017-09-12_15-31-40.txt... (5 Replies)
Discussion started by: Home
5 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I am facing one scenario in which I need to extract exact position of date and time from the name of the files. For example, Below is the record in which I need to extract position of YYYYMMDD,HHMISS and YYMMDD. Date and time variables can come more than once. I need to use these position... (13 Replies)
Discussion started by: Prathmesh
13 Replies
LEARN ABOUT DEBIAN
datetime::format::sqlite
DateTime::Format::SQLite(3pm) User Contributed Perl Documentation DateTime::Format::SQLite(3pm)
NAME
DateTime::Format::SQLite - Parse and format SQLite dates and times
SYNOPSIS
use DateTime::Format::SQLite;
my $dt = DateTime::Format::SQLite->parse_datetime( '2003-01-16 23:12:01' );
# 2003-01-16 23:12:01
DateTime::Format::SQLite->format_datetime($dt);
DESCRIPTION
This module understands the formats used by SQLite for its "date", "datetime" and "time" functions. It can be used to parse these formats
in order to create DateTime objects, and it can take a DateTime object and produce a timestring accepted by SQLite.
NOTE: SQLite does not have real date/time types but stores everything as strings. This module deals with the date/time strings as
understood/returned by SQLite's "date", "time", "datetime", "julianday" and "strftime" SQL functions. You will usually want to store your
dates in one of these formats.
METHODS
This class offers the methods listed below. All of the parsing methods set the returned DateTime object's time zone to the UTC zone
because SQLite does always uses UTC for date calculations. This means your dates may seem to be one day off if you convert them to local
time.
o parse_datetime($string)
Given a $string representing a date, this method will return a new "DateTime" object.
The $string may be in any of the formats understood by SQLite's "date", "time", "datetime", "julianday" and "strftime" SQL functions or
it may be in the format returned by these functions (except "strftime", of course).
The time zone for this object will always be in UTC because SQLite assumes UTC for all date calculations.
If $string contains no date, the parser assumes 2000-01-01 (just like SQLite).
If given an improperly formatted string, this method may die.
o parse_date($string)
o parse_time($string)
o parse_julianday($string)
These are aliases for "parse_datetime", for symmetry with "format_*" functions.
o format_date($datetime)
Given a "DateTime" object, this methods returnes a string in the format YYYY-MM-DD, i.e. in the same format SQLite's "date" function
uses.
o format_time($datetime)
Given a "DateTime" object, this methods returnes a string in the format HH:MM:SS, i.e. in the same format SQLite's "time" function
uses.
o format_datetime($datetime)
Given a "DateTime" object, this methods returnes a string in the format YYYY-MM-DD HH:MM:SS, i.e. in the same format SQLite's
"datetime" function uses.
o format_julianday($datetime)
Given a "DateTime" object, this methods returnes a string in the format DDDDDDDDDD, i.e. in the same format SQLite's "julianday"
function uses.
AUTHOR
Claus Faerber <CFAERBER@cpan.org>
based on "DateTime::Format::MySQL" by David Rolsky.
Copyright X 2008 Claus Faerber.
Copyright X 2003 David Rolsky.
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
http://datetime.perl.org/
http://www.sqlite.org/lang_datefunc.html
perl v5.10.1 2009-12-10 DateTime::Format::SQLite(3pm)