|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Report file extraction based on Date range
Post 302079864 by ganapati on Thursday 13th of July 2006 09:54:15 AM
07-13-2006
Report file extraction based on Date range
Hi all,
Iam writing a script, which will extract all the files from Start_Date to End_Date. Files are date stamped as YYYYMMDD. For ex:
Start_Date='20051001'
End_Date='20060331'
extract files such as........
ramp_20050810.rpt
ramp_20050915.rpt
ramp_20051001.rpt
ramp_20051010.rpt
ramp_20051114.rpt
ramp_20051218.rpt
ramp_20060112.rpt
ramp_20060310.rpt
ramp_20060417.rpt
ramp_20050530.rpt
I've tried with so many options, and struggled with date increments and comparisions. I dont have much experience in shell scripting but I love it.
Any help will be much appreciated.
Many Thanks and Regards,
Ganapati
Iam writing a script, which will extract all the files from Start_Date to End_Date. Files are date stamped as YYYYMMDD. For ex:
Start_Date='20051001'
End_Date='20060331'
extract files such as........
ramp_20050810.rpt
ramp_20050915.rpt
ramp_20051001.rpt
ramp_20051010.rpt
ramp_20051114.rpt
ramp_20051218.rpt
ramp_20060112.rpt
ramp_20060310.rpt
ramp_20060417.rpt
ramp_20050530.rpt
I've tried with so many options, and struggled with date increments and comparisions. I dont have much experience in shell scripting but I love it.
Any help will be much appreciated.
Many Thanks and Regards,
Ganapati
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, everyone,
Now I have a ".csv" file and I want to extract a string-like date value from the file, say, it is in the 2nd row of the file and it is in the fixed context like:
"
This is the file title, //Row 1
The lastest update happened on: 10-Mar-2006 //Row2
....//other irrelavent rows
"... (6 Replies)
Discussion started by: homer_hn
6 Replies
2. UNIX for Dummies Questions & Answers
Hi All,
I am a java devloper putting my hands on shell scripts.
Honestly it sounds coool and interesting
Presently I got stuck with the following requirement.
Get the messages from file. The messages in the file are as follows:
date|message1
date|message2
.
.
.
date is of... (2 Replies)
Discussion started by: ambharish
2 Replies
3. Shell Programming and Scripting
Hi All,
I want a shell script which can display the file with in the date range.
For Example I have 15 files with the following format
abc_01-01-2009.txt to abc_15-01-2009.txt.
Now I want to have the files between 4th of jan to 12th files.
How can I acheive this.
Advance... (1 Reply)
Discussion started by: fareed_do
1 Replies
4. Shell Programming and Scripting
hi all,
here is the description to my problem.
input parameters: $date1 & $date2
based on the range i need to select the archived files from the archived directory and moved them in to working directory.
can u please help me in writing the code to select the multiple files based on the... (3 Replies)
Discussion started by: bbc17484
3 Replies
5. Shell Programming and Scripting
Hello
does anyone know of an awk that will extract log file entries between a specific date and time range, eg:
awk '/15\/Dec\/2010:16:10:00/, /15\/Dec\/2010:16:15:00/' access_log
but one that works?
Or a free command line log file analysis tool/script?
I'd like to be able to view... (2 Replies)
Discussion started by: competitions
2 Replies
6. Shell Programming and Scripting
Hi,
Currently I am working on a script to automate the process of converting the log file from binary into text format. To achieve this, partly I am depending on my application’s utility for this conversion and the rest I am relying on shell commands to search for directory, locate the file and... (5 Replies)
Discussion started by: svajhala
5 Replies
7. Shell Programming and Scripting
Hi Guys,
I have the following problem. I have original file (org.txt) that looks like this
module v_1(.....)
//arbitrary number of text lines
endmodule
module v_2(....)
//arbitrary number of text lines
endmodule
module v_3(...)
//arbitrary number of text lines
endmodule
module... (6 Replies)
Discussion started by: kaaliakahn
6 Replies
8. Shell Programming and Scripting
Hello I would like to ask for help with a script to search a directory that contains many log files and based on a users input after being prompted, they enter a date range down to the hour which searches the files that contain that range.
I dont know how to go about this. I am hoping that the... (5 Replies)
Discussion started by: lostincashe
5 Replies
9. UNIX for Dummies Questions & Answers
My unix version is IBM AIX Version 6.1
I tried google my requirement and found the below answer,
find . -newermt “2012-06-15 08:13" ! -newermt “2012-06-15 18:20"
But newer command is not working in AIX version 6.1 unix
I have given my requirement below:
Input:
atr files:
... (1 Reply)
Discussion started by: yuvaa27
1 Replies
10. Shell Programming and Scripting
Hi ,
I have a situation where I need to search an xml file for the presence of a tag
<FollowOnFrom> and also , presence of partial part of the following tag <ContractRequest _LoadId and if these 2 exist ,then
extract the value from the following tag <_LocalId> which is
"CW2094139". There... (2 Replies)
Discussion started by: paul1234
2 Replies
LEARN ABOUT LINUX
cabextract
CABEXTRACT(1) General Commands Manual CABEXTRACT(1) NAME
cabextract - program to extract files from Microsoft cabinet (.cab) archives SYNOPSIS
cabextract [-ddir] [-f] [-Fpattern] [-h] [-l] [-L] [-p] [-q] [-s] [-t] [-v] cabinet files ... DESCRIPTION
cabextract is a program that un-archives files in the Microsoft cabinet file format (.cab) or any binary file which contains an embedded cabinet file (frequently found in .exe files). cabextract will extract all files from all cabinet files specified on the command line. To extract a multi-part cabinet consisting of several files, only the first cabinet file needs to be given as an argument to cabextract as it will automatically look for the remaining files. To prevent cabextract from extracting cabinet files you did not specify, use the -s option. OPTIONS
A summary of options is included below. -d dir Extracts all files into the directory dir. -f When testing or extracting cabinet files, corrupted MSZIP blocks will be ignored. A warning will be printed if a corrupted MSZIP block is encountered. -F pattern Only files with names that match the shell pattern pattern shall be listed, tested or extracted. On non-GNU systems, this match may be case-sensitive. -h Prints a page of help and exits. -l Lists the contents of the given cabinet files, rather than extracting them. -L When extracting cabinet files, makes each extracted file's name lowercase. -p Files shall be extracted to standard output. -q When extracting cabinet files, suppresses all messages except errors and warnings. -s When testing, listing or extracting cabinets which span multiple files, only cabinet files given on the command line shall be used. -t Tests the integrity of the cabinet. Files are decompressed, but not written to disk or standard output. If the file successfully decompresses, the MD5 checksum of the file is printed. -v If given alone on the command line, prints the version of cabextract and exits. Given with a list of cabinet files, it will list the contents of the cabinet files. AUTHOR
This manual page was written by Stuart Caie <kyzer@4u.net>, based on the one written by Eric Sharkey <sharkey@debian.org>, for the Debian GNU/Linux system. SEE ALSO
lcab(1) October 30, 2005 CABEXTRACT(1)