File in ascending order by row Post: 302914815

Sponsored Content

Top Forums Shell Programming and Scripting File in ascending order by row Post 302914815 by Skrynesaver on Thursday 28th of August 2014 05:41:50 AM

08-28-2014

Registered User

If I understand you correctly you wish to maintain the row order of the file then split each record into an ID followed by any number of ref=>value tupples and sort the fields on increasing value...

Code:

perl -ne 'chomp;($id,%r)=split;print $id;for (sort {$r{$a}<=>$r{$b}} keys %r){print " $_ $r{$_}"}print"\n";' tmp.txt
ID1 ref_C 5 ref_A 10 ref_B 30
ID2 ref_H 5 ref_G 12 ref_F 69

ETA explanation
To clarify the script above...
perl -ne ' use Perl stepping though each line of input and executing the following scriptlet
chomp; Strip off any newline character this means none of the strings will have a new line at the end of them
($id,%r)=split; tokenise the string assigning the first token to the $id variable and assign the rest of the tokens in name=> value pairs in %r
print $id; print the id
for (sort {$r{$a}<=>$r{$b}} keys %r){ step through the name=>value pairs in order of lowest value to highest value
print " $_ $r{$_}" print the name value pair out
}print"\n"; finally print a new line to replace the one we removed
' tmp.txt end of scriptlet and use tmp.txt as the input

Last edited by Skrynesaver; 08-28-2014 at 11:21 AM.. Reason: I have a few minutes to elucidate

This User Gave Thanks to Skrynesaver For This Post:

Skrynesaver

View Public Profile for Skrynesaver

Find all posts by Skrynesaver

10 More Discussions You Might Find Interesting

1. 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!!!!!!

2. 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...

3. UNIX for Advanced & Expert Users

merge two files in ascending order

Hello Friends, I want to merge two files in ascending order on the first field. And if the first field matches sort on 3rd field i.e, TXADDR should come ahead of RXADDR . file1 9 : TXADDR : 00000000 65 : TXDATA 0000000000000011 83 : TXDATA 0000000000000012 453 :...

4. 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

5. UNIX for Dummies Questions & Answers

Appending a column of numbers in ascending order to a text file

I have a text file where I want to append a column of numbers in ascending orders. Input: 57 abc 25 def 32 ghi 54 jkl Output:57 abc 57 abc 1 25 def 2 32 ghi 3 54 jkl 4 How do I go about doing that? Thanks!

6. Shell Programming and Scripting

File listing in Ascending order

I have a multiple file with the following name like. file_0.csv file_1.csv file_2.csv file_3.csv file_4.csv file_5.csv file_6.csv file_7.csv file_7.csv file_8.csv file_9.csv file_10.csv file_11.csv file_12.csv file_13.csv file_14.csv

7. 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...

8. 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?...

9. 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

10. Shell Programming and Scripting

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: file...

LEARN ABOUT OPENSOLARIS

print-service

print-service(1M)					  System Administration Commands					 print-service(1M)

NAME

       print-service - select, report, import, export active print service on a system

SYNOPSIS

       print-service  [-s service [-m] | -q | -e file | -i file]

DESCRIPTION

       The print-service utility manages print service selection, as well as export and import of basic print queue configuration.

       Only a user root privileges or with the Printer Management profile can change the active print service or import print queue configuration.

OPTIONS

       The following options are supported:

       -s service

	   Select the active print service for on a host. service can be one of lp or cups.

       -m

	   Migrate print queue configuration during print service selection.

       -q

	   Report the active print service on a host.

       -e file

	   Export basic print queue configuration to a file.

       -i file

	   Import basic print queue configuration from a file.

EXAMPLES

       Example 1 Selecting a Print Service

       The following command selects the CUPS print service as the active print service on a host.

	 # print-service -s cups

       Example 2 Reporting the Active Print Service

       The following command reports the active print service on a host.

	 # print-service -q

       Example 3 Exporting a Print Queue Configuration

       The following command exports the print queue configuration from the active print service.

	 # print-service -e /tmp/queues

       Example 4 Importing a Print Queue Configuration

       The following command imports the print queue configuration to the active print service.

	 # print-service -i /tmp/queues

EXIT STATUS

       0

	   Successful completion.

       non-zero

	   An error occurred.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWpcu			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Obsolete			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       intro(1), attributes(5)

NOTES

       The  print  queue  configuration  saved	and  restored during export, import, and migration is limited to queue name and device name. It is
       likely that further configuration changes will be required before imported or migrated print queues become usable.

SunOS 5.11							    18 Mar 2008 						 print-service(1M)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Sort / ascending order

Discussion started by: gyik

2. Shell Programming and Scripting

Ascending order within text

Discussion started by: kerpm

3. UNIX for Advanced & Expert Users

merge two files in ascending order

Discussion started by: user_prady

4. Shell Programming and Scripting

Ascending order

Discussion started by: kristinu