mjhjmtu

I have a list of timestamped filenames in this following format:

cat files

• ..201807010112.log


• ..201807020112.log


• ..201807022359.log


• ..201807030112.log


• ..201807010412.log

I need to get a certain range and in order to do this, I'd like to use SED.

sed -n '/201807010112/,/201807030112/p' 

Was my first attempt but sed treats the hour and minute strangely, and to make a long story short it's unable to understand this format correctly.

I may be getting in the weeds but in order to solve this, I've decided to convert the format to something SED understands.

cat files | sed -e "s/([0-9]12}/$(date -f '%Y%m%d%H%M' 1)/g"

My problem is that I cannot use the result of the match 1 in the date conversion block.

Is there a way to do this or better yet a better way to get the range of dates?

So I decided not to try to use date function to transform the form and instead use more SED!

cat files

• 
  

  ..._201807010112.log

  
  




• 
  

  ..._201807010132.log

  
  




• 
  

  ..._201807010152.log

  
  




• 
  

  ..._201807010202.log

  
  

The date is in the format YYYYmmddHHSS and I transformed it to the following format:

YYYY-mm-dd HH:SS using this regex expression with SED.

cat files | sed -e 's/(_[0-9]4)([0-9]2) 
([0-9]2)([0-9]2)([0-9]2) /1-2-3 4:5/g'

Next, from there it was a piece of cake to specify the range based on date.

 | sed -n '/2018-07-01 01:20/,/2018-07-02 02:01/p'

The biggest take away for me was knowing the proper date-time format to utilize SED's range pattern option.