'Crop' date from filename into a variable


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers 'Crop' date from filename into a variable
# 1  
Old 02-26-2009
'Crop' date from filename into a variable

Hi all,

I have a scenario as below. I created a file -

$touch myfile.onlytesting.20090227.txt

I want to assign the date only - 20090227 into a variable x.

How do I do this in unix command?

Please help. ThanksSmilie
# 2  
Old 02-26-2009
how about this:
Code:
d=$(date +"%Y%m%d")
touch myfile.onlytest.$d.txt

# 3  
Old 02-26-2009
If you are willing to extract the datefield enclosed in the file name, here is a solution:
Code:
ant:/home/vbe $ echo myfile.onlytesting.20090227.txt|awk -F\. '{print $(NF-1)}'
20090227

I suppose my other mates will give you a sed version very shortly...
# 4  
Old 02-26-2009
Quote:
Originally Posted by vbe
If you are willing to extract the datefield enclosed in the file name, here is a solution:
Code:
ant:/home/vbe $ echo myfile.onlytesting.20090227.txt|awk -F\. '{print $(NF-1)}'
20090227

I suppose my other mates will give you a sed version very shortly...

Hi.. this is working but what if my filename is below :
myfile.onlytesting.200902270000.txt

but I only want 20090227 to be extracted.. and omit the 0000. How do I do this? Thanks again Smilie
# 5  
Old 02-26-2009
step by step

There are many ways one of them..u can pipe it..this is for explanation...instead of awk you can use cut as well

Code:
 > x=myfile.onlytesting.20090227.txt
 > y=`basename $x .txt`
 > echo $y
myfile.onlytesting.20090227
> echo $y|nawk '{print substr($0,length-7)}'
20090227

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to change existing date to current date in a filename?

Suppose i have a list of files in a directory as mentioned below 1. Shankar_04152019_ny.txt 2. Gopi_shan_03122019_mi.txt 3. Siva_mourya_02242019_nd.txt .. . . . . 1000 . Jiva_surya_02282019_nd.txt query : At one shot i want to modify the above all filenames present in one path with... (4 Replies)
Discussion started by: Shankar455
4 Replies

2. Shell Programming and Scripting

How to append date to filename, but base it on yesterday's date?

Hello, I'd like to write a monthly archive script that archives some logs. But I'd like to do it based on yesterday's date. In other words, I'd like to schedule the script to run on the 1st day of each month, but have the archive filename include the previous month instead. Here's what I... (5 Replies)
Discussion started by: nbsparks
5 Replies

3. UNIX for Dummies Questions & Answers

How to change date in a filename?

Hi i want to list files based on date and change the date alone in the files in a directory abc20120101.txt xyzxyxz20120101.txt ccc20120201.txt ddd20120301.txt In the above i want to select only files having date 20120101 and rename the date for those files like below abc20111231.txt... (3 Replies)
Discussion started by: Dewdrop
3 Replies

4. Shell Programming and Scripting

Get the oldest date based on date in the filename

I am using ksh93 on Solaris. Ok, this may seem like a simple request at first. I have a directory that contains sets of files with a YYYYMMDD component to the name, along with other files of different filespecs. something like this: 20110501_1.dat 20110501_2.dat 20110501_3.dat... (2 Replies)
Discussion started by: gary_w
2 Replies

5. Shell Programming and Scripting

date from filename

Hi all I have the following question: With this command, I get the latest file in a directory. lastfile =`ls -1tr | tail -n 1` echo $lastfile The output is then: partner131210.txt (meaning 13th December 2010) My goal is to get the date into a variable and to obtain a final variable... (4 Replies)
Discussion started by: davis77
4 Replies

6. UNIX for Dummies Questions & Answers

Date in filename

how do i add the date for the filename? for example filename20080917 (3 Replies)
Discussion started by: khestoi
3 Replies

7. Shell Programming and Scripting

Get date from filename

Hi all, I have this files: aaa20080714.log bbbb20080714.log ccccccc20080714.log Can i get the 20080714 from each file? (6 Replies)
Discussion started by: icy_blu_blu
6 Replies

8. Shell Programming and Scripting

Concatenating the filename with date

Hi, I want to concatenate the filename with the current date using the get command in ftp. for ex: <filename><date> emp101_20080526 Can you please let me know the command for this. thanks, Aswarth. (9 Replies)
Discussion started by: Aswarth
9 Replies

9. Shell Programming and Scripting

mv Filename variable to another filename

Anyone who can assist : I am trying to pass the group vairiable to a filename: rpt_tsavegrp=/export/legato/scripts/$group_savegrp_rpt.$dat It will not pass to variable. Anyone have any ideas what I am doing wrong here. Thanks # This script sends email that save group completed.... (3 Replies)
Discussion started by: gzs553
3 Replies

10. Shell Programming and Scripting

filename to contain date

hello, can anyone tell me how to rename a filename in a script to contain the current date? i have searched for the answer but with little success! many thanks rkap (4 Replies)
Discussion started by: rkap
4 Replies
Login or Register to Ask a Question