Sponsored Content
Top Forums Shell Programming and Scripting Sort numbers which has colon (:) in between Post 302651437 by varu0612 on Wednesday 6th of June 2012 04:09:44 AM
Old 06-06-2012
Sort numbers which has colon (:) in between

Although i tried multiple option i couldn't find a way to get the rigt ouput.

Say i have the following data

Code:
cat file.txt
 
[1] C request
[1:1]
[1:4]
[1:2]
[1:3]
[1] C response
[2:3]
[2] C request
[2:1]
[2:2]
[2] C response

The output should look like

Code:
[1] C request
[1:1]
[1:2]
[1:3]
[1:4]
[1] C response
[2] C request
[2:1]
[2:2]
[2:3]
[2] C response

I've tried

Code:
sort -t: -k1,1n -k2,2n or sort -t: +1.1 -1.3

but no luck.

any idea?

Cheers.

Moderator's Comments:
Mod Comment edit by bakunin: please use [CODE]..[/CODE]-tags when psoting code or terminal output. Thank you.


---------- Post updated 06-06-12 at 09:09 AM ---------- Previous update was 06-05-12 at 06:37 PM ----------

Sorry - i'll remember and use it next time.

Do you have any idea on my request? Maybe i need to use awk + sort?


Thx in advance!

Last edited by bakunin; 06-05-2012 at 11:00 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to sort a string with numbers

Hi, I need help to sort a file contents. I am using sort -r option to basically reverse the comparison in descending order. However, i found out that my file is not sorted according, can anyone please help. My data is something like:- Hello world 20.982342864 343 19.234355545 222... (5 Replies)
Discussion started by: ahjiefreak
5 Replies

2. Shell Programming and Scripting

Sort by numbers, then alphabetically

Hey guys, I have a file that contains the following: 366 K 364 Q 12 UB 7 INC. P 4 Law 2 LAMB 2 High 1 QEG 1 OF 1 LC 1 B As you can see, it's already sorted by numerical order, how do I sort it again, breaking the ties by using the alphabetical order of the second column, but... (2 Replies)
Discussion started by: Andrew9191
2 Replies

3. Shell Programming and Scripting

How to Sort Floating Numbers Using the Sort Command?

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)
Discussion started by: daniel.gbaena
7 Replies

4. Shell Programming and Scripting

Sort numbers

Hello, okey so my script is using 4 variables that are either empty or numbers in the following format: NUMBER_1 NUMBER_2 NUMBER_3 NUMBER_4 So they're basically separated by a space and I need to echo the lowest number, so far I've been doing it like this: echo "2 3 1 3" | tr " "... (6 Replies)
Discussion started by: TehOne
6 Replies

5. Shell Programming and Scripting

Is it Possible to sort a list of hexadecimal numbers using "sort" command?

Hello Everybody :) !!!. i have question in mind, is it possible to sort a list of hexadecimal numbers using "sort" command? (9 Replies)
Discussion started by: Kesavan
9 Replies

6. Shell Programming and Scripting

How to sort version numbers?

I would like to know how to sort version numbers, using bash or perl. I would like to sort file names that are program names with version numbers and extensions, such as hello-0.2.3.tar.gz and hello-0.10.3.tar.gz. Version numbers of computer programs do not comply with the mathematical rule... (3 Replies)
Discussion started by: LessNux
3 Replies

7. Shell Programming and Scripting

how to sort numbers

I have files like this: 1 3 4 6 14 3 6 I want to extract the highest number. I have tried using cat filename | sort but then 9 would become higher than 14. So how do I sort? (1 Reply)
Discussion started by: locoroco
1 Replies

8. Shell Programming and Scripting

How to sort a column in UNIX that is colon separated ":" ?

Experts, how to sort this fields with numerical order : -How to use the sort command in this case, I was thinking with -k but it is not working, lan5000 lan5000:1 lan5000:10 lan5000:11 lan5000:12 lan5000:13 lan5000:14 lan5000:15 lan5000:16 lan5000:17 ... (6 Replies)
Discussion started by: rveri
6 Replies

9. Shell Programming and Scripting

Bash, remove numbers after colon

Hello All, I was wondering if someone might know how to do this. I have a word list that is format like the example below. I need to take away the :number after that... is there some kind of command I could use to remove them? 123456:5562 password:1507 123456789:989 qwerty:877... (7 Replies)
Discussion started by: 3therk1ll
7 Replies

10. Shell Programming and Scripting

Sort only numbers within a string

Hi, I am having contents in a file like below, cat testfile rpool/swap rpool/swap14 rpool/swap2 rpool/swap3 I want to sort the above contents like, rpool/swap rpool/swap2 rpool/swap3 rpool/swap14 I have tried in this way, (7 Replies)
Discussion started by: Sumanthsv
7 Replies
CUBRID_LOAD_FROM_GLO(3) 						 1						   CUBRID_LOAD_FROM_GLO(3)

cubrid_load_from_glo - Read data from a GLO instance and save it in a file

SYNOPSIS
int cubrid_load_from_glo (resource $conn_identifier, string $oid, string $file_name) DESCRIPTION
The cubrid_load_from_glo(3) function is used to read a data from a glo instance, and saves it in a designated file. PARAMETERS
o $conn_identifier -Connection identifier. o $oid -Oid of the glo instance that you want to read the data from. o $file_name -Name of the file where you want to save the data in. RETURN VALUES
TRUE, when process is successful. FALSE, when process is unsuccessful. EXAMPLES
Example #1 cubrid_load_from_glo(3) example <?php $req = cubrid_execute ($con, "select image from person where id=1"); if ($req) { list ($oid) = cubrid_fetch($req); cubrid_close_request($req); $res = cubrid_load_from_glo ($con, $oid, "output.jpg"); if ($res) { echo "image changed successfully"; } } ?> NOTES
Note For backward compatibility, the following deprecated alias may be used: cubrid_load_from_glo(3) Note This function is removed from CUBRID 3.1. SEE ALSO
cubrid_new_glo(3), cubrid_save_to_glo(3), cubrid_send_glo(3). PHP Documentation Group CUBRID_LOAD_FROM_GLO(3)
All times are GMT -4. The time now is 01:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy