03-20-2012
dealing with dates in a text file
hi guys im trying to write a bash script that grabs expired domain names it leaves me with the following outpiut in a text file
Quote:
1, test.com Expiration Date:17-jun-2013
2, test.net Expiration Date:29-mar-2013
3, test.org Expiration Date:26-Jul-2012 04:00:00
4, .test.biz Expiration Date:Mar 26 23:59:59 2012
5, test.info Expiration Date:27-Jul-2012 07:56:43
Im hoping to try to normalise all the dates to the format displayed in the first 2 lines and remove the times so the file looks unfirom can any one give me a heads up ?
Thanks for looking
Last edited by dunryc; 03-20-2012 at 02:37 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Can somebody help me in building a text file which will contain the dates of 2 yrs in the format YYYYMMDD using korn shell
e.g. to generate a file with the contents
20010101
20010102
...
...
20010131
20010201
...
...
20010228
20010301
...
and so on. (2 Replies)
Discussion started by: rkkiran
2 Replies
2. Shell Programming and Scripting
Hi,
What's the best way to find all files under a directory - including ones with space - in order to apply a command to each of them. For instance I want get a list of files under a directory and generate a checksum for each file.
Here's the csh script:
#!/bin/csh
set files = `find $1... (5 Replies)
Discussion started by: same1290
5 Replies
3. Shell Programming and Scripting
Hello friends,
I am looking for a script or method that can display all the dates between any 2 given dates.
Input:
Date 1
290109
Date 2
010209
Output:
300109
310109
Please help me. Thanks. :):confused: (2 Replies)
Discussion started by: frozensmilz
2 Replies
4. Shell Programming and Scripting
I have a text file in which holidays are listed as YYYYMMDD. Here is the sample data of the file.
20090911
20090912
20090913
I need to read this file and see if the current day is listed in this text file. If today and any of the rows in my text file match, I need to do further... (2 Replies)
Discussion started by: Pramodini Rode
2 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I am trying to print the dates that falls between 2 date variables into a file. Here is the example.
$BUS_DATE =20120616
$SUB_DATE=20120613
Output to file abc.txt should be : 20120613,20120614,120120615,20120616
Can you pls help me accomplish this in LINUX.
Thanks... (5 Replies)
Discussion started by: dsfreddie
5 Replies
6. UNIX for Advanced & Expert Users
Hi Am Using Unix Ksh ...
I have a Table called date
select * from date ;
Date
01/02/2013
06/02/2013
I need the output as
Missing Date
01/02/2013
02/02/2013
03/02/2013
04/02/2013
05/02/2013
06/02/2013 (2 Replies)
Discussion started by: Venkatesh1
2 Replies
7. UNIX for Advanced & Expert Users
Hey Guys ,
Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below :
1. Convert one XLS file with multiple tabs to multiple CSV files.
-- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But... (2 Replies)
Discussion started by: himanshu sood
2 Replies
8. Emergency UNIX and Linux Support
Hey Guys ,
Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below :
1. Convert one XLS file with multiple tabs to multiple CSV files.
-- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But... (6 Replies)
Discussion started by: himanshu sood
6 Replies
9. Shell Programming and Scripting
I need to sum values in text file in case duplicate row are present with same name and different value below is example of data in file i have and format i need.
Data in text file
20170308
PM,U,2
PM,U,113
PM,I,123
DA,U,135
DA,I,113
DA,I,1
20170309
PM,U,2
PM,U,1
PM,I,123
PM,I,1... (3 Replies)
Discussion started by: Adfire
3 Replies
10. Shell Programming and Scripting
hi all,
trying this using shell/bash with sed/awk/grep
I have two files, one containing one column, the other containing multiple columns (comma delimited).
file1.txt
abc12345
def12345
ghi54321
...
file2.txt
abc1,text1,texta
abc,text2,textb
def123,text3,textc
gh,text4,textd... (6 Replies)
Discussion started by: shogun1970
6 Replies
LEARN ABOUT OSX
date::calc::xs
Date::Calc::XS(3pm) User Contributed Perl Documentation Date::Calc::XS(3pm)
NAME
Date::Calc::XS - XS wrapper and C library plug-in for Date::Calc
SYNOPSIS
You never use this module directly. Use Date::Calc(3) instead!
DESCRIPTION
You never use this module directly. Use Date::Calc(3) instead!
SEE ALSO
Date::Calc(3), Date::Calc::PP(3).
VERSION
This man page documents "Date::Calc::XS" version 6.3.
AUTHOR
Steffen Beyer
mailto:STBEY@cpan.org
http://www.engelschall.com/u/sb/download/
COPYRIGHT
Copyright (c) 1995 - 2012 by Steffen Beyer. All rights reserved.
LICENSE
This package is free software; you can use, modify and redistribute it under the same terms as Perl itself, i.e., at your option, under the
terms either of the "Artistic License" or the "GNU General Public License".
The C library at the core of the module "Date::Calc::XS" can, at your discretion, also be used, modified and redistributed under the terms
of the "GNU Library General Public License".
Please refer to the files "Artistic.txt", "GNU_GPL.txt" and "GNU_LGPL.txt" in the "license" subdirectory of this distribution for any
details!
DISCLAIMER
This package is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the "GNU General Public License" for more details.
perl v5.14.2 2012-05-17 Date::Calc::XS(3pm)