OraFAQ Forum: Unix » extracting substring from a filename

Home » Infrastructure » Unix » extracting substring from a filename (Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

extracting substring from a filename [message #315765]

Tue, 22 April 2008 13:30

beetel
Messages: 96
Registered: April 2007

Member

Hi,
I am a beginner in Unix so please bear with me...
I have a directory which has files in format: RECF-YYYY-MM-DD-input. For example, RECF-2008-02-25-input. I need to extract the YYYYY-MM-DD substring from this filename and convert that into date and compare it with a date. How do I do that?
For instance, I have a directory with the following files:
RECF-2008-02-21-input
RECF-2008-02-22-input
RECF-2008-02-23-input
RECF-2008-02-24-input

I need to get the files whose date substrings are greater than 2008-02-22 (Feb 22, 2008) which are RECF-2008-02-23-input and RECF-2008-02-24-input in the examples above. Please help Smile

Thanks in advance.

Report message to a moderator

Re: extracting substring from a filename [message #315774 is a reply to message #315765]

Tue, 22 April 2008 14:05

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I am a beginner in Unix so please bear with me...

And this is an Oracle forum, so you should choose an Unix forum to post your question.

Regards
Michel

Report message to a moderator

Re: extracting substring from a filename [message #316099 is a reply to message #315774]

Wed, 23 April 2008 14:36

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Date arithmetic is shell scripting is really difficult. Most solutions I've seen use perl or whatever the person is comfortable with.

http://flux.org.uk/howto/perl/yesterday_date

Fortunately if you have 4 digit year, 2 digit month & day, then you have an easy job. Keep them in decending order of significance like you have them (yyyy mm dd), then string comparison of 2 dates will give the result you are after.

See http://www.orafaq.com/forum/t/100585/45693/ for ideas.

To compare files based on last mod time, you can touch a reference file with your own time (touch -t), then use (find -newer ...) to identify your files newer than that.

Report message to a moderator

Re: extracting substring from a filename [message #316102 is a reply to message #316099]

Wed, 23 April 2008 14:43

andrew again
Messages: 2577
Registered: March 2000

Senior Member

by the way... Using touch & newer allows you to have fine granularity with time.

find -mtime allows integers, so 24 hr is your granularity. As you are interested in the date contained in the filename - not the file date, then you need to work with the filename and the string sort like mentioned.

Report message to a moderator

Previous Topic:	tail command and time stamp
Next Topic:	unable to pass flexfield values from report wrapper to oracle applications seeded report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 10:55:54 CDT 2025