Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Search on date range of file based on user input
Top Forums Shell Programming and Scripting Search on date range of file based on user input Post 302616131 by Corona688 on Friday 30th of March 2012 02:17:43 PM
Old 03-30-2012
I don't see why it wouldn't work.

There's one thing in your favor -- YYYY MM DD HH MM SS dates sort alphabetically. ls will give you them in date order. Then all you do is an alphabetic < > comparison to see if they're in the range you want...

Code:
printf "Enter start YYYY/MM/DD HH "
# Should work for YYYY/MM/DD HH or YYYY MM DD HH
IFS="/ " read S_YYYY S_MM S_DD S_HH

printf "Enter end YYYY/MM/DD HH "
IFS="/ " read E_YYYY E_MM E_DD E_HH

EARLIEST="XSLog$S_YYYY.$S_MM.$S_DD-$S_HH.00.00.txt"
LATEST="XSLog$E_YYYY.$E_MM.$E_DD-$E_HH.59.59.txt"

ls -1 | awk -v E="$EARLIEST" -v L="$LATEST" '($0 >= E) && ($0 <= L)' | xargs sed -e '/./{H;$!d;}' -e 'x;/1234/!d'

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Log File date compare for user defined range

:confused: Hi i am a noob and need a little help to finish my shell script. I am learning as i go but hit a problem. I am search thorugh logs(*.rv) files to find entires between two user defined dates, The script so far looks for the "START" and "END" of each entry at sees if it belongs To... (0 Replies)
Discussion started by: mojo24
0 Replies

2. Shell Programming and Scripting

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... (2 Replies)
Discussion started by: ganapati
2 Replies

3. Shell Programming and Scripting

search file, change existing value based on input (awk help)

I have a file (status.file) of the form: valueA 3450 valueB -20 valueC -340 valueD 48 I am tailing a data.file, and need to search and modify a value in status.file...the tail is: tail -f data.file | awk '{ print $3, ($NF - $(NF-1)) }' which will produce lines that look like this: ... (3 Replies)
Discussion started by: nortonloaf
3 Replies

4. Shell Programming and Scripting

Append file based upon user input-- solved

Ok, I have a script with a commandline option that allows the user to add a custom function to the script file. I have tried everything in my limited knowledge of sed to get this to work and keep coming up short. I need sed to search for a line starting with a pattern, I've got that part so far,... (0 Replies)
Discussion started by: DC Slick
0 Replies

5. Shell Programming and Scripting

Search for a specific data in a file based on a date range

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

6. Shell Programming and Scripting

display Range of date depend on user input php

Hi, i am very new to php Is it possible to display Range of date depend on user input day example: user input 2 day start from 28/4/12 it will add 2 day from date of input so display should look like this 28/4/12 to 30/4/12 then from 30/412 user add another 4 date so will... (0 Replies)
Discussion started by: guidely
0 Replies

7. UNIX for Advanced & Expert Users

Help with ksh script to list, then cp files from a user input date range

Hi, I'm quite new to ksh scripting, can someone help me with this. Requirements: I need to create a script that list the files from a user input date range. e. g. format of file: *c1*log.2012-12-22-14-00* *c1*log.2012-12-22-14-00* *c1*log.2012-12-22-14-00*... (1 Reply)
Discussion started by: chococrunch6
1 Replies

8. UNIX for Dummies Questions & Answers

Find the count of files by last created date based on the given date range

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

9. Shell Programming and Scripting

Bash to search file based off user input then create new file

In the below bash a file is downloaded when the program is opened and then that file is searched based on user input and the result is written to a new file. For example, the bash is opened and the download.txt is downloaded, the user then enters the id (NA04520). The id is used to search... (5 Replies)
Discussion started by: cmccabe
5 Replies

10. Shell Programming and Scripting

awk command to search based on 5 user input fields

Field1=”” Field2=”” Field3=”” Field4=”” Field5=”” USER INPUT UP TO 5 FIELDS awk -F , '{ if ( $3 == Field1 && $6 == Field2 && $8 == Field3 && $9 == Field4 && $10 == Field5) print $0 }' /tmp/rodney.outD INPUT FILE (Rodney.outD): ... (3 Replies)
Discussion started by: rmerrird
3 Replies

LEARN ABOUT DEBIAN

torrus_srvderive

TORRUS_SRVDERIVE(8)						      torrus						       TORRUS_SRVDERIVE(8)

NAME

       srvderive - Derive a new service ID from sum or maximum of other service values

SYNOPSIS

       torrus srvderive TIMESPAN OUTPUT FUNCTION SOURCES...

DESCRIPTION

       When the Torrus Reporting engine is set up, this command is used to combine several services data into a new service ID. The output data is
       either the maximum or the sum of input services.

       See Torrus Reporting Setup Guide for more information.

TIMESPAN

       Either --month or --end option must be defined

       --start=YYYY-MM-DD
	   Sets the start date of the calculation.

       --end=YYYY-MM-DD
	   Sets the next day after the eond of the period.

       --month
	   Instead of setting the end data, it is convenient to use this option. It sets the end data in one calendar month after the start date.

OUTPUT

       --out=SERVICEID
	   Sets the output service ID. This should not be a service ID used in the Torrus datasource trees. Note: if srvderive command is run
	   twice with the same arguments, the produced data is doubled for the output service ID.

FUNCTION

       --func="MAX"|"SUM"
	   Sets the function to be used when combining the input service data.	Currently only "MAX" and "SUM" are supportted.

SOURCES

       --in=SERVICEID ...
	   Input service IDs are specified either by --in option, or as command line arguments. At least 2 input service IDs should be specified.

OPTIONS

       --step
	   Default: 300. Sets the data interval for derived service ID. It is recommended to leave this option at default value.

       --verbose
	   Prints extra informatgion.

       --debug
	   Prints debugging information.

       --help
	   Prints command usage information.

SEE ALSO

       torrus(8)

NOTES

       See more documentation at Torrus home page: http://torrus.org

AUTHOR

       Stanislav Sinyagin <ssinyagin@yahoo.com>

torrus 2.03							    2013-07-26						       TORRUS_SRVDERIVE(8)
All times are GMT -4. The time now is 01:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy