Dear all,
thank you for quick attempts to solve the sorting!
jim mcnamara: yes, this sorting literally means moving columns based on values in the first row.
Don Cragun: - yes, values in heading line (based on which i have to sort) contain a letter V followed by non-negative unique number.
- and your code gives me:
Looks like it not a trivial thing. Maybe I have to try to do it in R.
But thank you once more!
Last edited by Scott; 11-01-2017 at 08:03 AM..
Reason: Code tags
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)