Sort by values in the 1st row, leaving first four coulumns untouched
Dear all, will be thankful if you can help on sort command.
My data looks like (tab separated; number of columns 2317; N of rows ~200000):
I need to sort my data so, that first four columns remain untouched. Rest of the columns are sorted by values in the first row. Result will look like:
Thank you a lot for your help!
Last edited by jim mcnamara; 10-31-2017 at 04:15 PM..
I have a pipe delimited file. Key is field 2, date is field 5 (as example, my real file is more complicated of course, but the KEY and DATE are accurate)
There can be duplicate rows for a key with different dates.
I need to keep only rows with latest date in this case.
Example data: ... (4 Replies)
Hi
I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.
The original data record should be some thing like this
60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Hello All:
I've file in below format. File name is "FIRSTN.TBL":
AAAAAA N
BBBBBBBBBBBBBBBBBBBBBBB N
.
.
.
.
ZZZZZZZZZZZZZZZZZZZZZZZZZZ N
My file row length is 40 characters and my second column will start from 25th column and it is only... (3 Replies)
Hi, I need somebody's help with sorting data with awk.
I've got a file:
10 aaa 4584
12 bbb 6138
20 ccc 4417
21 ddd 7796
10 eee 7484
12 fff ... (5 Replies)
Hello,
How to sort each row in a document with numerical values and with more than one row. Example
Input data (file1.txt):
4 6 8 1 7
2 12 9 6 10
6 1 14 5 7
and I want the the output to look like this(file2.txt):
1 4 6 7 8
2 6 9 10 12
1 5 6 7 14
I've tried
sort -n file1.txt >... (12 Replies)
how can i sort the table based on first row? thanks in advance
input
name d b c a
l l1 l2 l3 l4
l1 1 2 3 4
l2 2 2 2 1
l3 1 1 2 2ouput
name a b c d
l1 l4 ... (4 Replies)
In the awk below I am trying to remove all instances after a ; (semi-colon) or , (comma) in the ANN= pattern. I am using gsub
to substitute an empty string in these, so that ANN= is a single value (with only one value in it the one right after the ANN=). Thank you :).
I have comented my awk and... (11 Replies)
Discussion started by: cmccabe
11 Replies
LEARN ABOUT DEBIAN
cssort
CSSORT(1p) User Contributed Perl Documentation CSSORT(1p)NAME
cssort -- Czech sort
FORMAT
cssort [ "-c"list | "-f"list ["-d"regexp]] [files ...]
SYNOPSIS
cssort -c10-15,50-,25-45 < file
cssort -f3,5-6 < file
cssort -f3,5-6 -s: < file
DESCRIPTION
Cssort is a utility that sorts input lines according to rules used in the Czech language. You can run it without any options, then it just
uses whole lines for sorting. With the options, it's possible to specify parts of the lines to be used for comparison.
list
A comma-separated list of integer field numbers or field ranges. The are indexed from 1 and if a range is open (eg. "5-"), it means all
remaining fields from the starting number.
-c Stands for columns and the list that follows specifies byte ranges on the line. You will probably use this option to sort data with
fixed width fields.
-f Fields that will be used for sort.
-d Delimiter that separates fields in the -f option. It is a Perl regular expression, the default is "[ ]+", which means any number of
spaces or tabs in a row.
The program assumes ISO-8859-2 encoding. Some way to specify another input encoding will come in the next versions. If you need to sort
files with different encodings, you might want to check the cstocs conversion utility.
SEE ALSO Cz::Sort(3), cstocs(1).
AUTHOR
Jan Pazdziora, adelton@fi.muni.cz.
perl v5.10.1 2010-01-16 CSSORT(1p)