10 More Discussions You Might Find Interesting
1. Programming
Hi All,
I have one requirement, where I need to have output of ls -l command sorted on 1) first on filename 2) last modified time ( descending ) - latest change first.
I am not able to figure out how to do it..
Also I dont have a way to change Date display for ls -ltr command..
I am... (1 Reply)
Discussion started by: freakabhi
1 Replies
2. UNIX for Dummies Questions & Answers
New to unix.
I need to sort the records of a file by a control number field. That field is in POS 16 through 28. How do I do that? There are no delimiters, or spaces to separate fields.
See example below. Each line is a record.
REC1CCYYMMDD0018888888888888ABCDE... (1 Reply)
Discussion started by: jclanc8
1 Replies
3. Shell Programming and Scripting
Hi,
I would like to sort a list in different ways:
1> Unique based on Field 1 with highest Field 4
For Instance Input:
1678923450;11112222333344;11-1x;2_File.xml
1678923450;11112222333344;11-1x;5_File.xml
1234567890;11113333222244;11-1x;3_File.xml
Output:
... (7 Replies)
Discussion started by: DevendraG
7 Replies
4. Shell Programming and Scripting
Is it possible to join all the values after sorting them based on 1st column key and replace empty rows with 0 like below ?
input
a1 0 a1 1 a1 1 a3 1 b2 1
a2 1 a4 1 a2 1 a4 1 c4 1
a3 1 d1 1 a3 1 b1 1 d1 1
a4 1 c4 1 b2 1
b1 1
b2 1
c4 1
d1 1
output... (8 Replies)
Discussion started by: quincyjones
8 Replies
5. Shell Programming and Scripting
hi all,
i have a file , having few columns. i wanted to sort it based on 2nd column and then based on 1st column. But i have some problem in first column.
first column have characters and numbers, but problem is number of characters are not same in all rows. Few rows have 13 characters and then... (3 Replies)
Discussion started by: deepakiniimt
3 Replies
6. Shell Programming and Scripting
Howdy!
Need to sort a large .txt file containing the following, using sort. First based on the 1st column, and then on the 2nd column:
Group01.01 1000500 31 0.913 -1.522974494
Group01.01 1001500 16 0.684 -0.967496041
Group01.01 36500 19 0.476 na
Group01.02 365500 15 0.400 na... (1 Reply)
Discussion started by: sramirez
1 Replies
7. Shell Programming and Scripting
Hi,
Is there any way to sort a file in cshell by sort command, sorting it by multiple fields, like to sort it first by the second column and then by the first column.
Thanks forhead (1 Reply)
Discussion started by: Takeeshe
1 Replies
8. Shell Programming and Scripting
hello..
I have big file and so far I was able to shink it and make smaller with certains values that I need..
vendor1|2000|1
vendor2|1000|1
vendor2|5000|1
vendor2|500|2
vendor3|1000|2
vendor3|500|3
vendor4|500|3
Vendor5|500|1
vendor6|500|3
Vendor7|1000|1
Vendor8|1000|774... (3 Replies)
Discussion started by: abdulaziz
3 Replies
9. UNIX for Dummies Questions & Answers
Hi, I am trying to sort a file first by the string column, then by the number column.
file:
xyz1 2
xyzX 4
xyz2 1
xyz13 3
xyz11 5
xyz13 10
xyz1 1
xyz10 1
xyz4 2
result should be
xyz1 1
xyz1 2 ... (3 Replies)
Discussion started by: fargo
3 Replies
10. Shell Programming and Scripting
I have a text file comprising of 3 columns
1. First column - numeric count/frequency of error codes
2. Second column - alphanumeric hyphenated error code
3. Third column - Error code description (alphanumeric)
184 ABCD-954 Errorcodedescription1
35645 DFMS-323 Errorcodedescription2
43534 ... (2 Replies)
Discussion started by: inditopgun
2 Replies
RS(1) BSD General Commands Manual RS(1)
NAME
rs -- reshape a data array
SYNOPSIS
rs [-[csCS][x] [kKgGw][N] tTeEnyjhHmz] [rows [cols]]
DESCRIPTION
The rs utility reads the standard input, interpreting each line as a row of blank-separated entries in an array, transforms the array accord-
ing to the options, and writes it on the standard output. With no arguments it transforms stream input into a columnar format convenient for
terminal viewing.
The shape of the input array is deduced from the number of lines and the number of columns on the first line. If that shape is inconvenient,
a more useful one might be obtained by skipping some of the input with the -k option. Other options control interpretation of the input col-
umns.
The shape of the output array is influenced by the rows and cols specifications, which should be positive integers. If only one of them is a
positive integer, rs computes a value for the other which will accommodate all of the data. When necessary, missing data are supplied in a
manner specified by the options and surplus data are deleted. There are options to control presentation of the output columns, including
transposition of the rows and columns.
The following options are available:
-cx Input columns are delimited by the single character x. A missing x is taken to be `^I'.
-sx Like -c, but maximal strings of x are delimiters.
-Cx Output columns are delimited by the single character x. A missing x is taken to be `^I'.
-Sx Like -C, but padded strings of x are delimiters.
-t Fill in the rows of the output array using the columns of the input array, that is, transpose the input while honoring any rows and
cols specifications.
-T Print the pure transpose of the input, ignoring any rows or cols specification.
-kN Ignore the first N lines of input.
-KN Like -k, but print the ignored lines.
-gN The gutter width (inter-column space), normally 2, is taken to be N.
-GN The gutter width has N percent of the maximum column width added to it.
-e Consider each line of input as an array entry.
-n On lines having fewer entries than the first line, use null entries to pad out the line. Normally, missing entries are taken from
the next line of input.
-y If there are too few entries to make up the output dimensions, pad the output by recycling the input from the beginning. Normally,
the output is padded with blanks.
-h Print the shape of the input array and do nothing else. The shape is just the number of lines and the number of entries on the first
line.
-H Like -h, but also print the length of each line.
-j Right adjust entries within columns.
-wN The width of the display, normally 80, is taken to be the positive integer N.
-m Do not trim excess delimiters from the ends of the output array.
-z Adapt column widths to fit the largest entries appearing in them.
With no arguments, rs transposes its input, and assumes one array entry per input line unless the first non-ignored line is longer than the
display width. Option letters which take numerical arguments interpret a missing number as zero unless otherwise indicated.
EXAMPLES
The rs utility can be used as a filter to convert the stream output of certain programs (e.g., spell, du, file, look, nm, who, and wc(1))
into a convenient ``window'' format, as in
% who | rs
This function has been incorporated into the ls(1) program, though for most programs with similar output rs suffices.
To convert stream input into vector output and back again, use
% rs 1 0 | rs 0 1
A 10 by 10 array of random numbers from 1 to 100 and its transpose can be generated with
% jot -r 100 | rs 10 10 | tee array | rs -T > tarray
In the editor vi(1), a file consisting of a multi-line vector with 9 elements per line can undergo insertions and deletions, and then be
neatly reshaped into 9 columns with
:1,$!rs 0 9
Finally, to sort a database by the first line of each 4-line field, try
% rs -eC 0 4 | sort | rs -c 0 1
SEE ALSO
jot(1), pr(1), sort(1), vi(1)
BUGS
Handles only two dimensional arrays.
The algorithm currently reads the whole file into memory, so files that do not fit in memory will not be reshaped.
Fields cannot be defined yet on character positions.
Re-ordering of columns is not yet possible.
There are too many options.
BSD
December 30, 1993 BSD