|
|
Sponsored Content
Top Forums
UNIX for Advanced & Expert Users
sorting data based on multi columns
Post 302107244 by anbu23 on Thursday 15th of February 2007 11:57:52 AM
02-15-2007
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I want a list of entries in 3 space delimited columns. I want to sort entries based on the very first column. Rows can't be changed. For example:
If I have...
Abc Abc Acc
Bca Bda Bdd
Cab Cab Cbc
Dbc Dca Dda
Abc Abc Acc
the output should be...
Abc Abc Acc
Abc Abc Acc
Bca... (7 Replies)
Discussion started by: MobileUser
7 Replies
2. Shell Programming and Scripting
Hi gang.
I'm using a unix/mac system and i'm trying to sort a file (more than 1,000,000 lines).
chr1 100000965 100001001 -
chr1 100002155 100002191 +
chr1 100002165 100002201 +
chr1 100002525 100002561 -
chr1 10000364 ... (2 Replies)
Discussion started by: labrazil
2 Replies
3. Shell Programming and Scripting
Hi,
I have a requirement whereby I have to sort a flat file based on Multiple Columns (similar to ORDER BY Clause of Oracle). I am getting 10 columns in the flat file and I want the file to be sorted on 1st, 3rd, 4th, 7th and 9th columns in ascending order. The flat file is pipe seperated.
Any... (15 Replies)
Discussion started by: dharmesht
15 Replies
4. Shell Programming and Scripting
Hi Friends
I have the following input data in 2 columns.
SNo 1
I1 Value
I2 Value
I3 Value
SNo 2
I4 Value
I5 Value
I6 Value
I7 Value
SNo 3
I8 Value
I9 Value
...............
................
SNo N (1 Reply)
Discussion started by: ks_reddy
1 Replies
5. Shell Programming and Scripting
Hi there,
Can someone let me know how to sort the 2 dimensional array below by column 1 then by column 2?
22 55
2222 2230
33 66
44 58
222 240
11 25
22 60
33 45
output:
11 25
22 55
22 60
33 45
33 66
44 58 (6 Replies)
Discussion started by: phoeberunner
6 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have two files, one of which I would like to sort based on the order of the data in the second. I would like to do this using a simple unix statement.
My two files as follows:
File 1:
12345 1 2 2 2 0 0
12349 0 0 2 2 1 2
12350 1 2 1 2 2 2
.
.
.
File2:
12350... (3 Replies)
Discussion started by: kasan0
3 Replies
7. Shell Programming and Scripting
Hi All,
I have some data like below.
Step1,Param1,Param2,Param3
1,2,3,4
2,3,4,5
2,4,5,6
3,0,1,2
3,0,0,0
3,2,1,3
........
so on
Where I need to find the median(arithmetic) of each column from Param1...to..Param3 for each set of Step1 values.
(Sort each specific column, if the... (5 Replies)
Discussion started by: ks_reddy
5 Replies
8. Shell Programming and Scripting
Hi All,
I need the modification for the below mentioned code (found in one more post https://www.unix.com/shell-programming-scripting/27161-script-generate-average-values.html) to find the average values for all the columns(but for a specific rows) and print the averages side by side.
I have... (4 Replies)
Discussion started by: ks_reddy
4 Replies
9. Shell Programming and Scripting
I have log files with following format -
YYYY/MM/DD HH:mm:ss.msec|field2|filed3| log message
Now the message itself can be multi line message containing new line character.
for e.g.
2013/02/05 15:33:12.234|abc|xyz| This is first single line message.
2013/02/05 15:33:12.786|abc|xyz| This... (6 Replies)
Discussion started by: gini32
6 Replies
10. Shell Programming and Scripting
I have data like this
1 a,b,c 2 a,c 3 b,d 4 e,f would like convert like this 1 a 1 b 1 c 2 a 2 c 3 b 3 d 4 e 4 f
Please help me out (4 Replies)
Discussion started by: jhonnyrip
4 Replies
LEARN ABOUT SUSE
ooconvert
ooconvert(1) User Commands ooconvert(1) Name ooconvert - Commandline Document Converter Using OpenOffice.org SYNOPSIS
ooconvert [--help] [--force] input output DESCRIPTION
This tool converts documents between various formats on the commandline. It uses OpenOffice.org that guarantees the quality of available import and export filters. This tool tries to start OpenOffice.org in the server mode on backgroud. It does not work if the OpenOffice.org application has already been running. Also it slows down the conversion a lot. We hope to reduce these limitations in the further versions. OPTIONS
input Input file. The filename suffix must be one of the currently supported file formats, see below. output Output file. The filename suffix defines the output file format. It must be one from the table below. An existing file can be over- written by the --force option. --help Print help and exit. --force Force an already existing output file to be replaced. SUPPORTED FILE FORMATS
The current version of this tool does not read the list of available input and output filters directly from OpenOffice.org. The list of supported file formats is hardcoded and thus limited to: doc Microsoft Word 97/2000/XP docx MS Word 2007 XML dot Microsoft Word 97/2000/XP Template dotx MS Word 2007 XML Template html HyperText Markup Language (Web Page) odt ODF Text Document ods ODF Spreadsheet odp ODF Presentation ott ODF Text Document Template ots ODF Spreadsheet Template otp ODF Presentation Template pdf Portable Document Format ppt Microsoft PowerPoint 97/2000/XP pptx Microsoft PowerPoint 2007 XML pot Microsoft PowerPoint 97/2000/XP Template potx Microsoft PowerPoint 2007 XML Template rtf Rich Text Format stc OpenOffice.org 1.0 Spreadsheet Template sti OpenOffice.org 1.0 Presentation Template stw OpenOffice.org 1.0 Text Document Template sxc OpenOffice.org 1.0 Spreadsheet sxi OpenOffice.org 1.0 Presentation sxw OpenOffice.org 1.0 Text Document swf Macromedia Flash txt Plain Text xls Microsoft Excel 97/2000/XP xlsx Microsoft Excel 2007 XML xlt Microsoft Excel 97/2000/XP Template xltx Microsoft Excel 2007 XML Template TROUBLESHOOTING PROBLEMS
See http://en.opensuse.org/Bugs:OOo for more details about how to report bugs in OpenOffice.org. AUTHOR
This manual page was created by Petr Mladek <petr.mladek@novell.com>. OpenOffice.org Converter 2009-02-09 ooconvert(1)