Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to sort the timestamp in the filename in shell script?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to sort the timestamp in the filename in shell script?
# 8  
Old 03-05-2014
Probably best to use sed to prepend the numeric value, sort and then cut the number:

Code:
ls *.csv | sed 's/.*_\([^_]*\)_[tT][mM]1.csv/\1 &/' | sort -n | sed 's/^[^ ]* //'

This User Gave Thanks to Chubler_XL For This Post:
feilhk
# 9  
Old 03-05-2014
Quote:
Originally Posted by feilhk
thanks for your answer, it work, but i discover that

the format is a bit different for users,

alex_li_20140304121212_tm1.csv

alex_cf_li_20140304121212_tm1.csv

there might be some user with extra underscore.

so counting from suffix is better, the time stamp si always before _tm1.csv, how do i change ls *.csv | sort -t_ -k3,3n to count the segment before _tm1.csv ?
You could try my awk script here...
Code:
ls -1t *.csv | awk -F"_" '{
   x[NR] = $(NF-1)
   y[$(NF-1)] = $0
} END {
   for (i=1; i<NR; i++)
       for (j=1; j<(NR+1-i); j++)
           if (x[j] > x[j+1]) {t = x[j];x[j] = x[j+1];x[j+1] = t}
   for (i=1; i<=NR; i++) print y[x[i]]
}'

# 10  
Old 03-05-2014
Quote:
Originally Posted by Chubler_XL
Probably best to use sed to prepend the numeric value, sort and then cut the number:

Code:
ls *.csv | sed 's/.*_\([^_]*\)_[tT][mM]1.csv/\1 &/' | sort -n | sed 's/^[^ ]* //'

i am new to shell script, coudl you help explain a little about the code, i have no idea how it works ..
# 11  
Old 03-05-2014
Code:
ls *.csv | awk '{match($0,/[0-9].*_/); printf $0"\t"; print substr($0,RSTART,RLENGTH-1)}' | sort -nr | cut -f1
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How can i make my cron/script to generate a log filename with timestamp in it ?

Hello Friends, I would like my script to display date timestamps in the file name for every script execution. Below is the scenario: (just for testing purpose) I scheduled a cron job, lets say it runs every 5 min and record/logs output in to a log file. 0,5,10,15,20,25,30,35,40,45,50,55 *... (5 Replies)
Discussion started by: System Admin 77
5 Replies

2. Shell Programming and Scripting

Filename timestamp

Hi Gurus, I have different files with different timestamp and different base file name, I have to group those files based on basename and provide a unique file name for similar file names. My Directory has following files. abc_filename_20130623:00:09:00.txt... (1 Reply)
Discussion started by: user_linux
1 Replies

3. Shell Programming and Scripting

Bash script to sort files into folder according to a string in the filename

Hi all. I am very new to linux scripting and i have a task i can only solve with a script. I need to sort files base on the date string in their filenames and create a folder using the same date string then move the files to their respective folders. Scenario: Folder Path:... (1 Reply)
Discussion started by: ace47
1 Replies

4. Shell Programming and Scripting

URGENT!!! bash script to sort files into folder according to a string in the filename

Hi all. I am very new to linux scripting and i have a task i can only solve with a script. I need to sort files base on the date string in their filenames and create a folder using the same date string then move the files to their respective folders. Scenario: Folder Path:... (1 Reply)
Discussion started by: ace47
1 Replies

5. Shell Programming and Scripting

Get filename with size and timestamp

Hi, Below is a directory containing links new2,list,new1. I need to get the size and timestamp for them. How do i get these details. Please help lrwxrwxrwx 1 xxx abc 11 Nov 24 17:34 new2 -> ./org1/new2 lrwxrwxrwx 1 xxx abc 11 Nov 24 17:34 list -> ./org2/list lrwxrwxrwx 1 xxx abc 10... (2 Replies)
Discussion started by: pradebban
2 Replies

6. UNIX for Dummies Questions & Answers

Shell script which will sort all the files in a directory with the timestamp they were created

Team, Pls help writing a shell script which will sort all the files in a directory with the timestamp they were created. (like ls -lrt) (6 Replies)
Discussion started by: asappidi
6 Replies

7. Shell Programming and Scripting

How to extract timestamp from the filename?

Hi., My file name is of the format: name_abc_20100531_142528.txt where., my timestamp is of the format: yyyymmdd_hhmmss How to extract the date strring and time string into seperate variables in the shell script, after reading the file as the input? I want to get the variables... (9 Replies)
Discussion started by: av_vinay
9 Replies

8. Shell Programming and Scripting

Timestamp in the filename

Hi i want to replace the previous time stamp with the current timsatp at the start of the file like 20090710_113354_FT0710a.txt this one to 20091111__113354_FT0710a.txt thanks in advance (3 Replies)
Discussion started by: Reddy482
3 Replies

9. Shell Programming and Scripting

add timestamp to filename

Does anyone know how to add a timestamp to a file's name extension in a shell script? Please help.. (3 Replies)
Discussion started by: walterja
3 Replies

10. UNIX for Dummies Questions & Answers

how to add a timestamp to a filename?

whats going on guys. below is a script i made and am just curious if there is a "time stamp" command. so i can set the timestamp in a filename. #! /bin/ksh # # This scripts takes a list of files in the INDIR variable and compairs it to a list of files that are open in the same directory.... (2 Replies)
Discussion started by: Optimus_P
2 Replies
Login or Register to Ask a Question