List numerically in ascending order


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting List numerically in ascending order
# 1  
Old 01-21-2020
List numerically in ascending order

Hello,
I am running ubuntu 16.04 and trying to list all files inside a directory, I need to sort them in ascending order. While surfing on the site, I found an old thread but somehow it did not work.
Link

Ascending order with sort -nk2 myfile.txt command gives below output:
Code:
file media_w1956306127_b2500000_0.ts
file media_w1956306127_b2500000_100.ts
file media_w1956306127_b2500000_101.ts
file media_w1956306127_b2500000_102.ts
..
..
file media_w1956306127_b2500000_10.ts
file media_w1956306127_b2500000_110.ts
file media_w1956306127_b2500000_111.ts
..
..
file media_w1956306127_b2500000_699.ts

Other method is a bit longer to do that. (Rename prefix media_w1956306127_b2500000_ in each filename, then, print the file names with for loop, variable from 0 to 699)

Could you please let me know how I may sort it as expected? Maybe sort command takes all strings as alphabet so it does not take into account the value of the string so that listing in ascending order does not give what I expected to get.

Thank you
Boris
# 2  
Old 01-21-2020
Hi, try
Code:
sort -t_ -k1,3 -k4n

This User Gave Thanks to Scrutinizer For This Post:
# 3  
Old 01-21-2020
Not sure I correctly understand your request. Are we talking of sorting a file, or a directory listing? Did you check for the links at the bottom of this page? Given "media_w1956306127_b2500000" is and stays constant in your data, how far would
Code:
sort -t"_" -nk4 file
..
..
..
..
file media_w1956306127_b2500000_0.ts
file media_w1956306127_b2500000_10.ts
file media_w1956306127_b2500000_100.ts
file media_w1956306127_b2500000_101.ts
file media_w1956306127_b2500000_102.ts
file media_w1956306127_b2500000_110.ts
file media_w1956306127_b2500000_111.ts
file media_w1956306127_b2500000_699.ts

get you?
This User Gave Thanks to RudiC For This Post:
# 4  
Old 01-21-2020
Thank you Dear Scrutinizer and Dear Rudic,
Your commands work good. Thank you again.
The text file includes all files inside the directory.
I do not understand why we need to specify underscore as limiter in column2. Normally each line is space seperated.
Thank you so much for your return.

Kind regards
Boris
# 5  
Old 01-21-2020
Quote:
Originally Posted by baris35
... why we need to specify underscore as limiter in column2 ...

That how we "isolate" the relevant numerical (!) sort field from the rest of fields that are considered strings. We're lucky here in that sort seems to disregard the .ts extension when extracting / calculating the numerical field.
This User Gave Thanks to RudiC For This Post:
# 6  
Old 01-21-2020
Hi
You can use the -V option
Code:
sort -V

or even sort right away in a file
Code:
vim -nes +'%!sort -V' +wq file

This User Gave Thanks to nezabudka For This Post:
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... (3 Replies)
Discussion started by: MDeBiasse
3 Replies

2. Shell Programming and Scripting

How to list files in ascending order?

Hi, I need to list files in ascending order. Filenames are in format inpTDT_1, inpTDT_2, inpTDT_3 and so on. I want to list them in the ascending order based on the digit after underscore and send the output to a file. Please help (5 Replies)
Discussion started by: Neelkanth
5 Replies

3. Shell Programming and Scripting

Arrange values in ascending order

HI I have a file # vi assc values order fin 100 34 45 200 12 64 120 10 23 Here I need to check whether the values of second column"order" is arranged ascendingly Note: Always order column will be arranged either in ascending or descending order How to make it?... (1 Reply)
Discussion started by: Priya Amaresh
1 Replies

4. Shell Programming and Scripting

Unable to list files in ascending order

Hi ! I am just trying to list my files in ascending order so that in some other software, I just want merge with some modification, when I list its coming like this new-10.txt new-11.txt new-12.txt new-13.txt new-14.txt new-15.txt new-16.txt new-17.txt new-18.txt new-19.txt... (2 Replies)
Discussion started by: nex_asp
2 Replies

5. UNIX for Dummies Questions & Answers

Strings in ascending order

Hi, I have a sequence which has 30000 strings which looks like this >string2991 234445 >string224 470561 >string121 675386 >string4098 177229 >string8049 255838 >string8 672382 >string1115 578415 I want it to be arranged in ascending order >string8 672382 >string121... (5 Replies)
Discussion started by: siya@
5 Replies

6. UNIX for Dummies Questions & Answers

sorting sequences in ascending order

Hi, I have this single file with a number of sequence inside it of format >string1 data >string100 data >string10 ..... >string5 ... >string67 ...... the dots represent data. I wanted to get the sequences arranged in ascending order like >string1 data >string5 (5 Replies)
Discussion started by: sonia102
5 Replies

7. Shell Programming and Scripting

Ascending order

How can I check if array is in ascending order? ---------- Post updated at 01:53 PM ---------- Previous update was at 01:25 PM ---------- Done it now (0 Replies)
Discussion started by: kristinu
0 Replies

8. Shell Programming and Scripting

How to list all the directories, sub directories in a mount along with size in ascending order?

Hi , I am very new to unix as well as shell scripting. I have to write a script for the following requirement. In a particular mount, have to list all the directories and sub directories along with size of the directory and sub directory in ascending order. Please help me in this regard and many... (4 Replies)
Discussion started by: nmakkena
4 Replies

9. Shell Programming and Scripting

Ascending order within text

I appreciate all the help that I've already received but am running into one problem. I can find how to add something before a file with ascending numbers but not like this. I basically have a file that looks like this: 100 101 102 103 104 I need to add the following before each line with... (5 Replies)
Discussion started by: kerpm
5 Replies

10. UNIX for Dummies Questions & Answers

Sort / ascending order

What's the command to sort a file in ascending order and redirect the output to another file? Thanks!!!!!! (1 Reply)
Discussion started by: gyik
1 Replies
Login or Register to Ask a Question