Split the records with a blank line, using a digit on the first position as the indicator of a new record
Replace the line terminators of records with an obscure character (paragraph character was used here (§), but it could be any character as long as it is not used in the input file) and remove the empty line that was introduced in step 1
Numeric reverse sort of the records on the 5th field
Reassemble the records to their original state by replacing the obscure character by a newline
Last edited by Scrutinizer; 12-07-2019 at 09:07 AM..
This User Gave Thanks to Scrutinizer For This Post:
Hi,
This is my input file:
ali 5 usa abc
abu 4 uk bca
alan 6 brazil bac
pinky 10 utah sdc
My desired output:
pinky 10 utah sdc
alan 6 brazil bac
ali 5 usa abc
abu 4 uk bca
Based on the column two, I want to do the descending order and print out other related column at the... (3 Replies)
Hi,
My input file is
$cat samp
1 siva
1 raja
2 siva
1 siva
2 raja
4 venkat
i want sort this name wise...alos need to remove duplicate lines.
i am using
cat samp|awk '{print $2,$1}'|sort -u
it showing
raja 1 (3 Replies)
I have a column of numbers in the following format:
1.722e-05
2.018e-05
2.548e-05
2.747e-05
7.897e-05
4.016e-05
4.613e-05
4.613e-05
5.151e-05
5.151e-05
5.151e-05
6.1e-05
6.254e-05
7.04e-05
7.12e-05
7.12e-05 (6 Replies)
Hi Guru,
I need some help regarding awking the output so it only show the first line (based on column) of each row.
So If column has 1, three row, then it only show the first line of that row, based on similar character in column 1. So i am trying to achieve a sort, based on column one and... (3 Replies)
Hi,
i need to sort content of files based on a specific value. An example as below.
Input1.txt
Col_1
SW_MH2_ST
ST_F72_9S
SW_MH3_S6
Col_2
SW_MH3_AS7
ST_S15_9CH
SW_MH3_AS8
SW_MH3_ST
Col_3
ST_M93_SZ
ST_C16_TC (12 Replies)
Hi,
I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column)
The input is for example, after sorted:
K00001 1 1 4 3... (8 Replies)
How to sort the following output based on lowest to highest BE?
The following sort does not work.
$ sort -t. -k1,1n -k2,2n bfd.txt
BE31.116 0s 0s DOWN DAMP
BE31.116 0s 0s DOWN DAMP
BE31.117 0s 0s ... (7 Replies)
Discussion started by: sand1234
7 Replies
LEARN ABOUT DEBIAN
dcsort
DCSORT(1) DICOM PS3 - Make sorted list of images DCSORT(1)NAME
dcsort - ACR/NEMA DICOM PS3 ... DICOM PS3 - Make sorted list of images
SYNOPSIS
dcsort " inputfile1 [ inputfile2 ... ]" [ -v|verbose ] [ -vv|veryverbose ] [ -vvv|veryveryverbose ] [ -index ] [ -show ] [ -interval ] [
-tolerance mm ] [ -check ] [ -checkFoR ] [ -descending ] [ -sortby|k attributename ]
DESCRIPTION
dcsort reads the named dicom input files and sorts them by the specified sort key.
The sort key should be a single valued numeric attribute, with the exception of ImageOrientationPatient and ImagePositionPatient which are
handled as special cases.
There is no output by default unless the index or verbose options are specified.
OPTIONS
The output and errors go to standard error.
The basic input switches are described in dcintro(1). Options specific to this program are:
-index
Creates a first column of output that is the index in the sort order, starting from 0, and a second column that is the filename.
-show
Show the value of the sort key after the file name with the -index option
-interval
Show the interval between values of the sort key, or an error if not equal
-tolerance mm
The tolerance value in mm to use when comparing intervals between slices; defaults to +/- 0.01 mm if unspecified
-check
Check that all the images are from the same series.
-checkFoR
Check that all the images have the same Frame of Reference (UID).
-descending
Sort in descending, rather than the default ascending, order.
-sortby|k attributename
Specify attributename as the sort key.
ENVIRONMENT EXAMPLES
% dcsort -index -sortby SliceLocation ./1/[0-9]*
0 ./1/1
1 ./1/2
FILES SEE ALSO dcintro(1)AUTHOR
Copyright (C) 1993-2010. David A. Clunie DBA PixelMed Publishing. All rights reserved.
BUGS DICOM PS3 22 December 2006 DCSORT(1)