The standard sort utility isn't able to perform a numeric sort on numbers at the end of a field when the string of characters before the numbers are variable length. And that is a very strange sort order (with house sorting after vol). And I don't understand why the following lines which are not in your input file:
are expected to magically appear in the output.
If you're willing to only output data that appears in your input file, we can sort in increasing order on the characters before the underscore, decreasing order on the characters after the underscore up to (but not including) any digits at the end, and then by increasing numeric order on any digits at the end using:
I'm using sed to pre-process your input to create three sort fields with <space> as the field delimiter, sort to sort the file (now with a constant field delimiter), and sed again to replace the removed underscore and get rid of the inserted <space>s. With your sample input file, this produces the output:
Location: Saint Paul, MN USA / BSD, CentOS, Debian, OS X, Solaris
Posts: 2,288
Thanks Given: 430
Thanked 480 Times in 395 Posts
Hi.
The code msort allows keys of the mode hybrid lexicographic-numeric comparison (for things like filenames and section headings, so that, e.g., 2a will precede 10b).
Hi,
Extremely new to Perl scripting, but need a quick fix without using TEXT::CSV
I need to read in a file, pass any delimiter as an argument, and convert it to bar delimited on the output. In addition, enclose fields within double quotes in case of any embedded delimiters.
Any help would... (2 Replies)
Hi,
I have a No Delimiter variable length text file with following schema -
Column Name Data length
Firstname 5
Lastname 5
age 3
phoneno1 10
phoneno2 10
phoneno3 10
sample data - ... (16 Replies)
I can not make it work, it prints \t rather than introduce tabs.
cut -d "," -f 4,8 Samples.csv --output-delimiter="\t" | sort > out
Since I am running this command within a shell script, I tried manually inserting tab in this command, still does not work. I am using bash shell
Suggestions... (8 Replies)
i am having text file below
NARGU S S 12358 SALES REP |22| Acccount/s
RAJU R B 64253 SALES REP |12| Acccount/s
RUKMAN S 32588 SALES REP |10| Acccount/s
NARGUND S S 12356... (3 Replies)
Hi,
I've a situation where,
a=xxx.yyy.zzz.txt
EXTN=`echo $a | cut -d . -f2`
Using the above code it delimites and will return "yyy.zzz.txt" to EXTN. But i need to get only the extension "txt". so as per the above code it delimits in the first "." itself. Can anyone help how to do... (6 Replies)
Hi to all.
I'm trying to sort this with the Unix command sort.
user1:12345678:3.5:2.5:8:1:2:3
user2:12345679:4.5:3.5:8:1:3:2
user3:12345687:5.5:2.5:6:1:3:2
user4:12345670:5.5:2.5:5:3:2:1
user5:12345671:2.5:5.5:7:2:3:1
I need to get this:
user3:12345687:5.5:2.5:6:1:3:2... (7 Replies)
Hi All,
Can the cut command have double character delimiter?
If yes, how can we use it.
if my data file contains :
apple || mango || grapes
i used
cut -f1 -d"||" filename
but got an error.
Plz help....
Thanks. (1 Reply)
Hello All,
I'm trying to use the sort command on a text file, the delimiter used in this file is a non-prining character '\027'
I tried to use the command -t option but it's not really working.
sort +n4 -t'\027' filename <<-- this is what I was trying and not working.
Your help is... (1 Reply)
hello..
my prob is as follows:
i have to read from a file which may have different formats depending upon the delimiter used in the data of the file.now i need that the user input the delimiter.the input delimiter is stored in a variable and is used on cut command to retrieve necessary... (3 Replies)