bash - unix sort for 2 fields numeric order -


I need to sort some data with Unix sort but I can not understand the exact syntax, the data appears < / P>

  3. 9.1 Step 10: 3. 9.11 Phase 20: 3.8.10 Step 20: 3.10.2 Step 10: 3.8.4 Phase 9 3.8.4 Phase 100: 3.8.4 Step 10:   

I want to sort it by using a large number first, then step number, like the above given data.

  3.8.4 Phase 10: 3.8.4 Phase 90: 3.8.4 Phase 100: 3.8.10 Phase 20: 3. 9.1 Step 10: 3. 9. 1 step 20: 3.10.2 step 10:   

I found a way to sort by first number on this site:

  sort -t             P> 

unix sort ('theory and practice in construction a work order routine' , J. L. Linderman, AT & T Bell Labs Tech Journal, October 1984) Unfortunately, not available on the Internet, AFAICT (I saw a year ago and I did not get it, I was again Ekha now, and you can find the reference, but the article does not). In addition to other things, it has been shown in the article that for Unix sorting , compared to the time compared to the time, it is not much surprising (when you think that comparison Per-set of fields per line is compared, there is a question of switching data 'bus indicators). One consequence of this was that they suggest what to suggest; Mapping key is easy to compare. He showed that a simple scripting solution could really save time with hard work.

Therefore, you may want to consider using a character that is unlikely to appear in the data file (such as Control-A ) as the key field separator In.

  sed 's /^\([^.]*\)[[](([^.]* \] [.] \ ([^] * \) Phase \ ( [0- 9] * \): * / \ 1 ^ a \ 2 ^ a \ 3 ^ a \ 4 ^ a and / 'file | sort -t' ^ a '-k1,1n -k2,2n -k3 , 3n-k4,4n | Sed 's /^.*^ A //'   

The first order is difficult, it identifies the 4 digit areas, and selects the selected character (written < Outputs differently from code> ^ A above, typed as control-A ), and then outputs a copy of the original line. This sequence is then the first four Works numerically on areas, and the last sed earns E in front of each row and the last Ctrl-A original line back again.

Comments

Popular posts from this blog

Python SQLAlchemy:AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

java - How not to audit a join table and related entities using Hibernate Envers? -

mongodb - CakePHP paginator ignoring order, but only for certain values -