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
tag(3tcl) tag(3tcl)
NAME
tag - Manipulate tagged files
SYNOPSIS
tag option ?arg arg ...?
DESCRIPTION
The tag procedure provides a number of options for manipulating tagged files.
COMMANDS
tag readfile filename
Reads the file with the given filename and returns a list where each list element is a tag record, which is represented by a list of
label-value pairs, or label-value-endlabel triples.
The tag header is the first element returned.
tag writefile filename list
Takes a list in the format used internally in tcl programs for tagged data and writes it as a tagged file.
tag extract list tests
Takes a list in tagged format, and a list of conditions, and returns a new list in tagged format which contains those tag records
which match the conditions.
The tests is a list of test items, each of which is a list of the form { labelname condition matchvalue }
The conditions are
== String equals
!= String not equal
<= Less than or equal
-in Is the test value a member of the list given as the matchvalue
-contains
Does the match value contain the test value as a case insensitive substring.
-earlier
Date earlier
-later Date later - dates are in ISO format (yyyy-mm-dd [hh:mm:ss]).
-exists
Does the label exist in this record.
BUGS
tag readfile reads the whole file into memory before turning it into a list. Should be more memory efficient.
The -earlier and -later comparisons require TCL8.3
AUTHOR
John Lines (john@paladin.demon.co.uk)
July 3, 2000 tag(3tcl)