Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

pull range of dates/times and put into new file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting pull range of dates/times and put into new file
# 1  
Old 03-08-2010
pull range of dates/times and put into new file
Need to pull from a range of dates/times (ex. 6:00 AM March 3 through 6:00 AM March 4) from a folder and put those file names in a new file to process later. Dates would not be hard dates but dates from the folder directory, how would I do that?
# 2  
Old 03-08-2010
More info needed.

When you say 'pull from a range of dates/times (ex. 6:00 AM March 3 through 6:00 AM March 4) from a folder', are these 'names' the names of files? Lines in a single or multiple text files?
# 3  
Old 03-08-2010
yes... Names are the names of the files in the folder
# 4  
Old 03-08-2010
Are you trying to get just the time stamp of the file or is the name of the file also the date stamp?

Post a sample listing of the file names.
# 5  
Old 03-08-2010
from time/date stamp pull names of files and put into a new file


Files Names:
E-PKG.Mortgage3DayDisclosure-Fixed-FirstMortgage-Prime-InstallmentLoan-3d658cc00a5b4b9e3a83bd2f5b3b498d-200000446910.zip Date Modified 3/8/2010 4:50 PM

N-PKG.MortgageAppraisalDelivery-Fixed-FirstMortgage-Prime-InstallmentLoan-3d0f5a590a5b4b97cc5fc9f04299b229-200000446610.zip Date Modified 3/8/2010 6:50 AM

E-PKG.Mortgage3DayDisclosure-Fixed-FirstMortgage-Prime-InstallmentLoan-3c78cd200a5b4b9e3a83bd2fb8bc2982-200000445310.zip Date Modified 3/8/2010 3:30 PM

N-PKG.MortgageAppraisalDelivery-Fixed-FirstMortgage-Prime-InstallmentLoan-3c067f900a5b4b9f23fb8dc929018cfb-200000445110.zip Date Modified 3/8/2010 1:10 PM

N-PKG.MortgagePrivacyNotice-null-FirstMortgage-Prime-null-364efccc0a5b4b974796f3d496680391-999918501.zip Date Modified 3/8/2010 9:30 PM
# 6  
Old 03-08-2010
OK, now post how you want the lines in the file to look like based on those file names...
# 7  
Old 03-08-2010
Please post "ls -la" directory listing of one of the files mentioned. This is to clarify the exact format of modified date and time stamp.

Please state whether the directory containing the files has subdirectories.

Please state approximately how many files there are in the directory.

Please post your Operating System and preferred shell (e.g. bash, ksh, etc.).

There are two common approaches to selecting all files between two dates. One involves using extensions to the "date" command in Linux to convert a character date into a binary date suitable for comparison. Another more portable unix/Linux solution involves creating temporary reference files with specific timestamps and using unix "find" (or even shell file timestamp comparison commands) to decide which files fall between the range.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Display data from a range of dates

I have a data in a file called SCHED which has 5 columns: sched no, date, time, place and remarks. The image is shown below. http://dl.dropbox.com/u/54949888/Screenshot%20from%202013-01-02%2002%3A42%3A25.png Now, I want to display only the schedules which fall under a certain date range which... (2 Replies)
Discussion started by: angilulu
2 Replies

2. UNIX for Dummies Questions & Answers

How to write the dates between 2 dates into a file

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

3. Emergency UNIX and Linux Support

show div on select - range of dates

Hi, I am sure this is simple, but I am breaking my head. I need 1 page with at the top a range of dates, 2002, 2003, 2004 etc If you select 2002 it will show the content of 1 div, if you select 2002 the content of another div. this is for showing announcements on a site, right now there... (1 Reply)
Discussion started by: lawstudent
1 Replies

4. Shell Programming and Scripting

Trying to pull a variable out of an xml file...

Hello. I'm new to *ix and am trying to pull a variable or two from an xml document. The document is in the format: <name>7_3(A).mov</name> <description>Some description from a file</description> <updatename>7_3_A.mov</updatename> <updatepath>Dailies Released</updatepath> ... (3 Replies)
Discussion started by: Renfield
3 Replies

5. Shell Programming and Scripting

How to put date range from a perl & sql script

Hi Guys, Can someone please help me on adding/inserting a variable date to an sql scipt? Basically I want to assign a 7 days date range. As shown below.. #!/usr/bin/perl use strict; use Env qw(ORACLE_HOME); my $SQLPLUS='/opt/oracle/product/10.1.0/db_1/bin/sqlplus -S... (1 Reply)
Discussion started by: pinpe
1 Replies

6. Shell Programming and Scripting

Using 'date' to list a range of dates

Hi guys, I have been trying to create a list of dates from a certain range, ie. range from 01011950 to 31122000 But when my below code reaches certain dates, it comes up with a; 'date: invalid date 'yyyy-mm-dd -d 1day' Sofar I have come up with the following, slow and ugly; ... (4 Replies)
Discussion started by: TAPE
4 Replies

7. Shell Programming and Scripting

How pull the Data from the file and should be mailed

Hi All, I need to pull the data from a file from 2 set of directories & should be mailed. I have a code , it is failing for some reason. Do somebody correct me where my script is going wrong. Directories: 1st Set of Directory /176_PS/Transactions/**/syslog.log ** : prd1 prd2... (2 Replies)
Discussion started by: raghunsi
2 Replies

8. Shell Programming and Scripting

Pull log between two dates.

Hi, I am trying to pull out lines from logs between two dates, the logs has lines like this : conn=552 op=3 msgId=17228 - RESULT err=0 tag=97 nentries=0 etime=0 dn="cn=amldapuser,ou=dsame u sers,dc=abc,dc=com" conn=553 op=-1 msgId=-1 - fd=34 slot=34 LDAP connection from 52.99.164.14 to... (4 Replies)
Discussion started by: john_prince
4 Replies

9. Shell Programming and Scripting

How do I pull a substring out of a file?

I'm new to shell scripting and am trying to write a small script that pulls a substring out of a file that has a few lines of text in it. The file will eventually have a lot of text, I just put a few lines in it for testing purposes. Anyway, this is what I have so far... #!/bin/ksh ... (4 Replies)
Discussion started by: enator45
4 Replies

10. UNIX for Dummies Questions & Answers

Display dates within a given date range

Hi All, I have a requirement to display all the dates within the provided (through user input) date range. For eg: If I enter 28012009 (as From date in the format 'DDMMYYYY') and 02022009(as To date in the format 'DDMMYYYY'), the output should be all dates occuring between the from and to... (11 Replies)
Discussion started by: sunpraveen
11 Replies
Login or Register to Ask a Question