Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

File Sorting by file name

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File Sorting by file name
# 1  
Old 11-21-2008
File Sorting by file name
Hello,

I need to sort unix files by name i.e based on datetime. Can you please guide how to sort the files

file name format like ddmmyyhhmiss.csv

300907160001.csv
290608160001.csv
281007160001.csv
270507160001.csv
040508160001.csv

Thanks in advance

Parijat
# 2  
Old 11-21-2008
Like with ls?

ls -lt --> newest to oldest
ls -ltr --> oldest to newest
# 3  
Old 11-21-2008
Thank you for your reply, but it will not work for my case. I don't want files to be sorted base on the file creation date. File name itself a date.

300907160001.csv
290608160001.csv
281007160001.csv
270507160001.csv
040508160001.csv
# 4  
Old 11-21-2008
Hammer & Screwdriver
This example works from a file, but you should be able to modify to accomodate your request.

Code:
> cat file77
300907160001.csv
290608160001.csv
281007160001.csv
270507160001.csv
040508160001.csv
> sort file77 -k 1.5,1.6 -k 1.3,1.4 -k 1.1,1.2
270507160001.csv
300907160001.csv
281007160001.csv
040508160001.csv
290608160001.csv

# 5  
Old 11-21-2008
How about ls -lr:

300907160001.csv
290608160001.csv
281007170001.csv
281007160001.csv
270507160001.csv
060508160001.csv
040508160001.csv

I added a few more filenames and it seems to sort like you want.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Emergency UNIX and Linux Support

Sorting file content by file extensions

Hi Experts, I have one .txt file which has filenames with various extensions e.g. .gz,.dat,.CTL,.xml. I want to sort all the filenames as per their extensions and would like to delete all the file names with .xml extension. Please help. PS : I am using Sun OS Generic_122300-60. ... (9 Replies)
Discussion started by: ajaypatil_am
9 Replies

2. Solaris

What about sorting a 5G file?

Hi Guys, My client (dear clients, I hate to love you) has the funky idea of sorting a 5G flat file. Certainly enough, this is taking forever and also fulls the / of our machine. Any idea of how we could proceed to make this a little bit more efficient? Maybe by forcing sort to "stay in... (7 Replies)
Discussion started by: plmachiavel
7 Replies

3. UNIX for Dummies Questions & Answers

Sorting data in file based on field in another file

Hi, I have two files, one of which I would like to sort based on the order of the data in the second. I would like to do this using a simple unix statement. My two files as follows: File 1: 12345 1 2 2 2 0 0 12349 0 0 2 2 1 2 12350 1 2 1 2 2 2 . . . File2: 12350... (3 Replies)
Discussion started by: kasan0
3 Replies

4. UNIX Desktop Questions & Answers

Sorting a file

I have a file that has the following 4 fields separated by a colum, Name, Street Address,City and State, Zip code. I want to sort the file by zip code. I tried this and it is not working. Please help! awk -f filename '{ print $4 " " $1 " " $2 " " $3 " " } |sort -n (2 Replies)
Discussion started by: Pouchie1
2 Replies

5. UNIX for Dummies Questions & Answers

sorting s file

how would i sort a file on the third column based on numerical value instead of the ASCII order? (1 Reply)
Discussion started by: trob
1 Replies

6. Shell Programming and Scripting

Finding & Moving Oldest File by Parsing/Sorting Date Info in File Names

I'm trying to write a script that will look in an /exports folder for the oldest export file and move it to a /staging folder. "Oldest" in this case is actually determined by date information embedded in the file names themselves. Also, the script should only move a file from /exports to... (6 Replies)
Discussion started by: nikosey
6 Replies

7. Shell Programming and Scripting

File Sorting As Per The Name

hello Please tell me the command to sort files in specific directory i have several files in one directory the files names are 2006-01-25 2006-01-23 2006-01-08 2006-01-07 I WANT TO DISPLAY FILES DATEWISE . THE LATEST DATE SHOULD BE FIRST FILE AND OLDEST WILL BE LAST ONE PLS... (10 Replies)
Discussion started by: getdpg
10 Replies

8. Shell Programming and Scripting

Sorting file

I have the file as follow: A: 60 B: 80 C: 40 D: 11 E: 100 I want to sort the file and get the output to file as follow: E: 100 B: 80 A: 60 C: 40 D: 11 Could any one help me please? (1 Reply)
Discussion started by: moutaz1983
1 Replies

9. Programming

regarding file sorting

i ahve a file like: ************************************* sree 122132 12321 *********************************** phani 21321 3213214 ****************************** dddsds 213213123 23213213 ******************************* i want to sort the file with respect to name how we can do this... (1 Reply)
Discussion started by: phani_sree
1 Replies

10. Shell Programming and Scripting

Help sorting file.

Hi, I have this file (filex) 07-11-2003 10:11:12!cccc!ddd!eeeeeeee 07-11-2003 09:11:11!dddd!kkkkk!xxxxxx 09-12-2003 14:18:43!aaaa!bbbbb!cccc where I need to sort it by date+time in this order: 09-12-2003 14:18:43!aaaa!bbbbb!cccc 07-11-2003 10:11:12!cccc!ddd!eeeeeeee 07-11-2003... (3 Replies)
Discussion started by: gio123bg
3 Replies
Login or Register to Ask a Question