How to sort files in directory numerically?

Login or Register to Ask a Question and Join Our Community

How to sort files in directory numerically?

Tags

aix, directory, files, ksh, newbies, sort, unix

Login to Discuss or Reply to this Discussion in Our Community

Top Forums UNIX for Beginners Questions & Answers How to sort files in directory numerically?

01-29-2020

Registered User

53, 4

Join Date: Feb 2014

Last Activity: 1 September 2020, 4:46 PM EDT

Location: Montreal

Posts: 53

Thanks Given: 3

Thanked 4 Times in 4 Posts

How to sort files in directory numerically?

Trying to sort a bunch of files numerically but can't seem to get the command just right. This is in a IBM AIX machine.

I have a directory that has...

Code:

backup.bk1
backup.bk100
backup.bk2
backup.bk200
backup.bk3
backup.bk300

There are a lot more files but this is shortened for the example.

If I simply do a ls -l on the directory I get..

Code:

backup.bk1
backup.bk100
backup.bk2
backup.bk200
backup.bk3
backup.bk300

I need the list to include the full directory path (in this case the files are stored in /usr1/temp) and the file name like this..

Code:

/usr1/temp/backup.bk1
/usr1/temp/backup.bk2
/usr1/temp/backup.bk3
/usr1/temp/backup.bk100
/usr1/temp/backup.bk200
/usr1/temp/backup.bk300

Anyone able to help me out?

Moderator's Comments:

Mod Comment

Please use code tags, as required by forum rules.
Thanks!

Last edited by Peasant; 01-29-2020 at 12:45 PM.. Reason: Added code tags.

c3rb3rus

View Public Profile for c3rb3rus

Find all posts by c3rb3rus

01-29-2020

Moderator

1,484, 567

Join Date: Mar 2011

Last Activity: 28 November 2020, 9:34 AM EST

Posts: 1,484

Thanks Given: 68

Thanked 567 Times in 444 Posts

Are there any attempts or ideas from your side, some code you gave a shot ?

Regards
Peasant.

Peasant

View Public Profile for Peasant

Find all posts by Peasant

01-29-2020

Registered User

53, 4

Join Date: Feb 2014

Last Activity: 1 September 2020, 4:46 PM EDT

Location: Montreal

Posts: 53

Thanks Given: 3

Thanked 4 Times in 4 Posts

Yes I tried using this..

Code:

ls -l /usr1/tmp/backup.bk* | sort -tk -k 3.1b,3n

But it does not give the desired results, I am reading through the sort manual but it is very confusing.

c3rb3rus

View Public Profile for c3rb3rus

Find all posts by c3rb3rus

01-29-2020

Registered User

15,129, 5,008

Join Date: Jul 2012

Last Activity: 4 May 2020, 4:31 PM EDT

Location: Aachen, Germany

Posts: 15,129

Thanks Given: 735

Thanked 5,008 Times in 4,483 Posts

I find your approach working. Could be somewhat simplified, like

Code:

ls  back* | sort -tk -k3n
backup.bk1
backup.bk2
backup.bk3
backup.bk100
backup.bk200
backup.bk300

With your -l option to ls, which outputs user and group of the file - is it possible those files' have a k in either of the two fields?

RudiC

View Public Profile for RudiC

Find all posts by RudiC

01-29-2020

Registered User

2,202, 340

Join Date: Apr 2007

Last Activity: 10 May 2020, 8:59 AM EDT

Location: 44.21.48N 80.50.15W

Posts: 2,202

Thanks Given: 3

Thanked 340 Times in 306 Posts

Code:

t(){
for file in $(ls *.bk*)
do
    n=$(echo $file |cut -dk -f3)
    echo $n $file
done
} 
l()
{
while read a b
do
    echo $b
done
}
t |sort -n|l

This User Gave Thanks to jgt For This Post:

jgt

View Public Profile for jgt

Visit jgt's homepage!

Find all posts by jgt

01-29-2020

Registered User

53, 4

Join Date: Feb 2014

Last Activity: 1 September 2020, 4:46 PM EDT

Location: Montreal

Posts: 53

Thanks Given: 3

Thanked 4 Times in 4 Posts

Using the script you provided works, thank you

c3rb3rus

View Public Profile for c3rb3rus

Find all posts by c3rb3rus

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

[Solved] Reverse the order of a list of file names (but not sort them alphabetically or numerically)

Hello all, I have a list of file names in a text document where each file name consists of 4 letters and 3 numbers (for example MACR119). There are 48 file names in the document (they are not in alphabetical or numerical order). I would like to reorder the list of names so that the 48th name is...

2. UNIX for Dummies Questions & Answers

Redirecting tmp files of SORT into different directory

Hey Guys, I am facing an annoying scenario, fewer times when I execute the sort command, it throws out on error saying that "No Space on available on /var/tmp/<temp file name>. May be it is set to /var/tmp directory. I was wondering, if I cant redirect the temporary file creation to any other...

3. Shell Programming and Scripting

Sort alphabetically, then numerically

Greetings - I'm not necessarily new to bash scripting - I'm probably between beginner and intermediate, but I have something that I just cannot figure out after many attempts to find it. I have a file that is merely a list of many files, with their respective paths, and a branch path (ClearCase)...

4. Shell Programming and Scripting

Sort numerically a non numerical

Hello, I have this sample data: 01 * * * * 01 * * * * 01 * * * * 01 * * * * 01 0 * * * 01 0 * * * 01 0 * * * 01 0 * * * 02 * * * 0 02 * * * 0 02 * * * 6 02 * * * 6 02 0 * * 1 02 0 * * 1 02 0 * * 2 02 0 * * 2 02 0 * * 3

5. UNIX for Dummies Questions & Answers

Sort 2 columns numerically

Hi, A basic query. In the example file below, I want to sort by column 1 and then by column 2 numerically. I have tried sort -k2n,1 file1 but while this sorts the columns in the correct order, it does not sort column 2 numerically. Any help would be much appreciated. Also, if you have time to...

6. Shell Programming and Scripting

Numerically sort problem for a long list of file name

I got a long list of file name. My input: data_1.txt data_2.txt data_3.txt data_10.txt data_21.txt data_12.txt data_4.txt My desired output: data_1.txt data_2.txt data_3.txt data_4.txt data_10.txt data_12.txt data_21.txt Does anybody got idea how to archive it?

7. Shell Programming and Scripting

How to sort a set of files by date in a directory?

hi there, I have a directory which contents I can parse dynamically. I end up with a file list. I then want to display those files sorted by date, oldest files first. I have very very little PERL experience...Would anyone know how to do that ? Thanks in advance.

8. UNIX for Dummies Questions & Answers

Sort file alphabetically AND numerically

Hi all. I have 2 files like this: f1 A 10 B 80 C 9 f2 A 11 B 700 C 10 What I want is the concatenation of the two files sorted by name (alphabetically) and size (numerically), so the result should be like this: F3 (cat f1 f2 sorted) A 10 A 11 B 80 B 700

9. UNIX for Dummies Questions & Answers

Sort all files in a directory retaining originals

Hi, I need to sort all the files in a directory whilst retaining the originals. So if in the directory I have: File1 File2 File3 I want to sort these files so that I would have: File1 File1.sort File2 File2.sort File3 File3.sort where I have added the .sort extension to show...

10. AIX

loop through the directory for files and sort by date and process the first file

hello i have a requirement where i have a direcotry in which i get files in the format STOCKS.20080114.dat STOCKS.20080115.dat STOCKS.20080117.dat STOCKS.20080118.dat i need to loop through the directory and sort by create date descending order and i need to process the first file. ...

Login or Register to Ask a Question