Sorting of alphanumeric filenames..


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Sorting of alphanumeric filenames..
# 1  
Old 02-02-2012
Sorting of alphanumeric filenames..

Hi All,
I want sort following files in ascending order.

exp_installer_CC4160-file10.dmp
exp_installer_CC4160-file11.dmp
exp_installer_CC4160-file12.dmp
exp_installer_CC4160-file13.dmp
exp_installer_CC4160-file14.dmp
exp_installer_CC4160-file15.dmp
exp_installer_CC4160-file16.dmp
exp_installer_CC4160-file1.dmp
exp_installer_CC4160-file20.dmp
exp_installer_CC4160-file22.dmp
exp_installer_CC4160-file2.dmp
exp_installer_CC4160-file3.dmp
exp_installer_CC4160-file4.dmp
exp_installer_CC4160-file5.dmp
exp_installer_CC4160-file6.dmp
exp_installer_CC4160-file7.dmp
exp_installer_CC4160-file8.dmp
exp_installer_CC4160-file9.dmp

Required Output to be like this:

exp_installer_CC4160-file1.dmp
exp_installer_CC4160-file2.dmp
exp_installer_CC4160-file3.dmp
exp_installer_CC4160-file4.dmp
exp_installer_CC4160-file5.dmp
exp_installer_CC4160-file6.dmp
exp_installer_CC4160-file7.dmp
exp_installer_CC4160-file8.dmp
exp_installer_CC4160-file9.dmp
exp_installer_CC4160-file10.dmp
exp_installer_CC4160-file11.dmp
exp_installer_CC4160-file12.dmp
exp_installer_CC4160-file13.dmp
exp_installer_CC4160-file14.dmp
exp_installer_CC4160-file15.dmp
exp_installer_CC4160-file16.dmp
exp_installer_CC4160-file20.dmp
exp_installer_CC4160-file22.dmp
# 2  
Old 02-02-2012
Code:
$ nawk -F"file" '{print $1 "file " $2}' input.txt | sort -k2 -n | sed 's/ //'
exp_installer_CC4160-file1.dmp
exp_installer_CC4160-file2.dmp
exp_installer_CC4160-file3.dmp
exp_installer_CC4160-file4.dmp
exp_installer_CC4160-file5.dmp
exp_installer_CC4160-file6.dmp
exp_installer_CC4160-file7.dmp
exp_installer_CC4160-file8.dmp
exp_installer_CC4160-file9.dmp
exp_installer_CC4160-file10.dmp 
exp_installer_CC4160-file11.dmp 
exp_installer_CC4160-file12.dmp
exp_installer_CC4160-file13.dmp
exp_installer_CC4160-file14.dmp
exp_installer_CC4160-file15.dmp
exp_installer_CC4160-file16.dmp
exp_installer_CC4160-file20.dmp 
exp_installer_CC4160-file22.dmp

# 3  
Old 02-02-2012
This should be sufficient:
Code:
sort -t- -nk2.5 input.txt

This User Gave Thanks to balajesuri For This Post:
# 4  
Old 02-02-2012
Thanks a lot..

Hi,

I am working as Jr.Dba in one private company. I am working on some linux scripts (bash shell) which will automate dump import into database. Some clients will send more than ten dump files with their respective comapny name as file extension.

Ex: dell1.dmp, dell2.dmp.....dell33.dmp
Ex: hcl1.dmp, hcl2.dmp.....hcl33.dmp
Ex: cephlon1.dmp, cephlon2.dmp.....cephlon33.dmp

so i need common linux scripts which will sort alphanumeric file names based on last two digits or more usnig bash shell

Regards,
RK

---------- Post updated at 11:00 AM ---------- Previous update was at 10:12 AM ----------

Very nice...Thanq....
It is working fine if a copied dump files in sequence order, but if i copied random order then it showing wrong output.

Ex: file2, file3, file1,file4,file7,file9,file8....

Last edited by gramakrishna; 02-02-2012 at 02:42 AM.. Reason: another requirement
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sorting alphanumeric strings without a pattern

Good evening to all!! I'm facing this problem: I saved in a txt a list of files name (one txt for every folder): hello0.jpg hello1.jpg hello10.jpg hello11.jpg hello12.jpg hello13.jpg hello14.jpg hello15.jpg hello16.jpg hello17.jpg hello18.jpg hello19.jpg hello2.jpg hello20.jpg... (32 Replies)
Discussion started by: silver18
32 Replies

2. Shell Programming and Scripting

Sorting a list of filenames but keeping the path information.

Hi All I've googled around for this and can't see a way of doing it. I have a file that contains a number of records that are layed out something like the following. /path/to/directory/that/contains/a/file/I/need/filename.pdf The path itself can vary both in terms of the names and the... (7 Replies)
Discussion started by: Bashingaway
7 Replies

3. Shell Programming and Scripting

Alphanumeric to integer

Hi folks, I have a value like A12,i could able to change this into integer using typeset as below typeset -i A12 But, I need your advice to change the values like 1A2 or 12A into integer. Thanks in advance. Thanks, Sathish (3 Replies)
Discussion started by: bsathishmca
3 Replies

4. Shell Programming and Scripting

get rid of non-alphanumeric characters

Hi! Could anyone so kindly help me a code to eliminate from a txt file, obtained by collecting and merge several web-page, every word (string) containing non alphabetical, numeric and punctuation character (i.e NON a-zA-Z0-9, underscore and punctuation mark)? Thanks a lot for the help to... (5 Replies)
Discussion started by: mjomba
5 Replies

5. Shell Programming and Scripting

Sorting with non- and alphanumeric characters

Hi guys, I'm new to this forum and I'm not a UNIX expert. I can't figure out this certain problem i'm having: I need to sort some words, some of the words are annotations (enclosed within < and >). I need to have them sorted alphabetically with all non-alphanumeric characters up front. For... (2 Replies)
Discussion started by: fed.m.ang
2 Replies

6. UNIX for Advanced & Expert Users

alphanumeric Sorting

Hi , I have a requirement where one column have to be sorted (delimiter is pipe) for eg: My input filed is as below 1|FIAT|0010103|23011|01/01/2000|31/12/9999|1.15 2|232|613|1 2|234|743|1 2|234|793|1 2|234|893|1 1|FIAT|0010103|23012|01/01/2000|31/12/9999|1.15 2|230|006|0 2|230|106|0... (9 Replies)
Discussion started by: laxmi131
9 Replies

7. Shell Programming and Scripting

alphanumeric comparision

I have a requirement where I need to check if where r1v07l09ab is a software release. I should always check for this to be true to continue the release deployment because an older release should not be deployed by mistake. I mean only the release greater than the current release should be... (3 Replies)
Discussion started by: rakeshou
3 Replies

8. UNIX for Dummies Questions & Answers

AlphaNumeric String Operations

Hi :) I am writing a ksh I have a string of general format A12B3456CD78 the string is of variable length the string always ends with numbers (here it is 78.. it can be any number of digits may be 789 or just 7) before these ending numbers are alphabets (here it is CD can even be... (3 Replies)
Discussion started by: lakshmikanth
3 Replies

9. Shell Programming and Scripting

sort command - alphanumeric

I have a file I'm trying to sort such as fred1 fred2 fred10 fred11 ... when I sort I get fred1 fred10 fred11 fred2 ... using sort can any give me the syntax to sort this is dict order e.g., (4 Replies)
Discussion started by: gefa
4 Replies

10. UNIX for Advanced & Expert Users

Sorting filenames by order in another file

I would like to arrange /sort filenames ending with suffix like ".00XXXX". where X is a digit. However the order of arrangement is in a text file and is 'harpharzard'. e.g the text file may be like 002345 009807 001145 I wanted to avoid doing this using sql and exporting the text file back to... (4 Replies)
Discussion started by: samudimu
4 Replies
Login or Register to Ask a Question

Featured Tech Videos