Get filenames without timestamp


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Get filenames without timestamp
# 1  
Old 07-30-2013
Get filenames without timestamp

Hi,

In my previous post I looked for timestamp to be added to the filename
https://www.unix.com/shell-programmin...sing-find.html
Now how do I select those files that do not have timestamp in the filenames.
I tried the following. My file has extension either *.out or *.bad.
Code:
echo "abcdef.test.1234.20130722133919.out" | grep -v '[0-9]\{14\}\.[out|bad]'

Though it did give good results, the above code can be any 14 consecutive numbers. How does the grep/sed/awk knows the pattern as YYYYDDMMHHMISS.out or YYYYDDMMHHMISS.bad

The script should not pick the files that has timestamp in the filename.


Thanks for your help
# 2  
Old 07-30-2013
With GNU/Linux utilities:
Code:
x='abcdef.test.1234.20130722133919.out'
echo $x | cut -d. -f4 | sed 's/\(.\{8\}\)\(.\{2\}\)\(.\{2\}\)\(.\{2\}\)/\1 \2:\3:\4/' | xargs -I{} date -d {} 1&>/dev/null
if [ $? -ne 0 ]
then
    echo "Bad date in file"
    exit 1
fi


Last edited by balajesuri; 07-30-2013 at 11:11 AM..
# 3  
Old 07-30-2013
I encountered the following error
date: illegal option -- d
Usage: date [-u] [+Field Descriptors]

I have the following version of unix (ksh)
AIX <hostname> 1 6 00F736154C00
# 4  
Old 07-30-2013
Try this regular expression in grep. Be warned that this regex is better than the one in post #1, but not completely fool-proof. For e.g., it could still give a GO for 20130631 or 20130230 which are invalid dates.
Code:
201[0-9]\(0[1-9]\|1[0-2]\)\([0-2][1-9]\|3[01]\)\([01][0-9]\|2[0-3]\)[0-5][0-9][0-5][0-9]\.\(out\|bad\)


Last edited by balajesuri; 07-30-2013 at 12:04 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grep lines between last hour timestamp and current timestamp

So basically I have a log file and each line in this log file starts with a timestamp: MON DD HH:MM:SS SEP 15 07:30:01 I need to grep all the lines between last hour timestamp and current timestamp. Then these lines will be moved to a tmp file from which I will grep for particular strings. ... (1 Reply)
Discussion started by: nms
1 Replies

2. Shell Programming and Scripting

AIX : Need to convert UNIX Timestamp to normal timestamp

Hello , I am working on AIX. I have to convert Unix timestamp to normal timestamp. Below is the file. The Unix timestamp will always be preceded by EFFECTIVE_TIME as first field as shown and there could be multiple EFFECTIVE_TIME in the file : 3.txt Contents of... (6 Replies)
Discussion started by: rahul2662
6 Replies

3. Shell Programming and Scripting

To check timestamp in logfile and display lines upto 3 hours before current timestamp

Hi Friends, I have the following logfile. Currently time in india is 07/31/2014 12:33:34 and i have the following content in logfile. I want to display only those entries which contain string 'Exception' within last 3 hours. In this case, it would be the last line only I can get the... (12 Replies)
Discussion started by: srkmish
12 Replies

4. Shell Programming and Scripting

How to append timestamp in the filenames using find?

Hi, How to change the filenames with timestamp in sub folders I have the following code to select the records. find . -type f -name '*pqr*' -ctime 1 -print The following is the example app_root_dir="/`echo $ScriptDir | cut -d'/' -f2`" $app_root_dir/../BadFiles directory uvw.bad... (3 Replies)
Discussion started by: bobbygsk
3 Replies

5. Shell Programming and Scripting

Identifying files with a timestamp greater than a given timestamp

I need to be able to identify files with file timestamps greater than a given timestamp. I am using the following solution, although it appears to compare files at the "seconds" granularity and I need it at the milliseconds. When I tested my solution, it missed files that had timestamps... (3 Replies)
Discussion started by: nkm0brm
3 Replies

6. Shell Programming and Scripting

Check if a date field has date or timestamp or date&timestamp

Hi, In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date&timestamp. I have to figure out the the data is a date or time stamp or date&timestamp. If it is date then append "<space>00:00:00"... (1 Reply)
Discussion started by: machomaddy
1 Replies

7. UNIX for Dummies Questions & Answers

How to compare a file by its timestamp and store in a different location whenever timestamp changes?

Hi All, I am new to unix programming. I am trying for a requirement and the requirement goes like this..... I have a test folder. Which tracks log files. After certain time, the log file is getting overwritten by another file (randomly as the time interval is not periodic). I need to preserve... (2 Replies)
Discussion started by: mailsara
2 Replies

8. Shell Programming and Scripting

Getting a relative timestamp from timestamp stored in a file

Hi, I've a file in the following format 1999-APR-8 17:31:06 1500 3 45 1999-APR-8 17:31:15 1500 3 45 1999-APR-8 17:31:25 1500 3 45 1999-APR-8 17:31:30 1500 3 45 1999-APR-8 17:31:55 1500 3 45 1999-APR-8 17:32:06 1500 3 ... (1 Reply)
Discussion started by: vaibhavkorde
1 Replies

9. UNIX for Dummies Questions & Answers

renaming filenames

I have 7 files with 7 different names coming into a specified folder on weekly basis, i need to pick a file one after another and load into oracle table using sql loader. I am using ksh to do this. So in the process if the file has error records and if sql loader fails to load into oracle tables,... (0 Replies)
Discussion started by: vpv0002
0 Replies

10. Shell Programming and Scripting

conversion of different timestamp to standard timestamp

hi i need a scrit to convert one date format to another. for example i have three columns in a file which gets a different format, but lastly i want output with stadard timestamp as "yyyy-mm-dd hh:mm:ss" column1 column2 ... (2 Replies)
Discussion started by: dprakash
2 Replies
Login or Register to Ask a Question