Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sort the multi column rows
Top Forums Shell Programming and Scripting Sort the multi column rows Post 302436024 by clx on Friday 9th of July 2010 03:46:54 AM
Old 07-09-2010
from second column, do you mean this "[5/Jul/2010:00:59:59" ??

Code:
$ sort -k2 file
abc       [5/Jul/2010:00:59:59    +0000]
xyz    [5/Jul/2010:00:10:00    +0000]
-    [5/Jul/2010:06:10:00    +0000]
-    [5/Jul/2010:06:10:00    +0000]
-    [5/Jul/2010:06:50:00    +0000]
-    [5/Jul/2010:07:10:00    +0000]
-    [5/Jul/2010:08:10:00    +0000]
-    [5/Jul/2010:09:10:00    +0000]
-    [5/Jul/2010:10:00:00    +0000]
-    [5/Jul/2010:10:10:00    +0000]
-    [5/Jul/2010:10:15:00    +0000]
-    [6/Jul/2010:06:10:00    +0000]
-    [6/Jul/2010:07:10:00    +0000]
$

you can provide many options in sort, if this is not the case, please provide the expected output.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

find and remove rows from file where multi occurrences of character found

I have a '~' delimited file of 6 - 7 million rows. Each row should contain 13 columns delimited by 12 ~'s. Where there are 13 tildes, the row needs to be removed. Each row contains alphanumeric data and occasionally a ~ ends up in a descriptive field and therefore acts as a delimiter, resulting in... (1 Reply)
Discussion started by: kpd
1 Replies

2. UNIX for Dummies Questions & Answers

Sort on multi columns

Hope someone can help, I am trying to sort a generic file like this test2 A 468 0 test2 R 468 1 test2 E 468 1 test2 R 468 3 test2 R 468 4 test2 R 468 459 test2 Z 468 0 test1 A 191 0 test1 R 191 191 test1 Z 191 0 test3 A 3 0 test3 R 3 3 test3 Z 3 0 test0 A 1 0 test4 A 1 0 test4 E... (2 Replies)
Discussion started by: gio001
2 Replies

3. UNIX for Dummies Questions & Answers

Alphabetical sort for multi line records contains in a single file

Hi all, I So, I've got a monster text document comprising a list of various company names and associated info just in a long list one after another. I need to sort them alphabetically by name... The text document looks like this: Company Name: the_first_company's_name_here Address:... (2 Replies)
Discussion started by: quee1763
2 Replies

4. Shell Programming and Scripting

awk command to print only selected rows in a particular column specified by column name

Dear All, I have a data file input.csv like below. (Only five column shown here for example.) Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 3,2,4,5,6 5,3,5,5,6 From this I want the below output Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies

5. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

I have 2 files, file01= 7 columns, row unknown (but few) file02= 7 columns, row unknown (but many) now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there e.g. file 01 James|0|50|25|10|50|30... (1 Reply)
Discussion started by: A-V
1 Replies

6. Shell Programming and Scripting

How to substract selective values in multi row, multi column file (using awk or sed?)

Hi, I have a problem where I need to make this input: nameRow1a,text1a,text2a,floatValue1a,FloatValue2a,...,floatValue140a nameRow1b,text1b,text2b,floatValue1b,FloatValue2b,...,floatValue140b look like this output: nameRow1a,text1b,text2a,(floatValue1a - floatValue1b),(floatValue2a -... (4 Replies)
Discussion started by: nricardo
4 Replies

7. UNIX for Dummies Questions & Answers

[Solved] Deleting all rows where the first column equals the second column

Hi, I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks! Input: 1 1 ABC DEF 2 2 IJK LMN 1 2 ZYX OPW Output: 1 2 ZYX OPW (2 Replies)
Discussion started by: evelibertine
2 Replies

8. Shell Programming and Scripting

Converting Single Column into Multiple rows, but with strings to specific tab column

Dear fellows, I need your help. I'm trying to write a script to convert a single column into multiple rows. But it need to recognize the beginning of the string and set it to its specific Column number. Each Line (loop) begins with digit (RANGE). At this moment it's kind of working, but it... (6 Replies)
Discussion started by: AK47
6 Replies

9. UNIX for Dummies Questions & Answers

Egrep multi rows

I have file input input.txt 20140730|13|TORONTO|Pavja|13127|Moto|0|1568|2035|-467|59478|352450|2014-08-11 23:12:15 20140730|13|TORONTO|Pavja|13127|Manual|0|696|742|-46|38826|141449|2014-08-11 23:12:15 20140730|13|TORONTO|Pavja|13127|Semimanual|0|0|3|-3|0|317|2014-08-11 23:12:15... (6 Replies)
Discussion started by: radius
6 Replies

10. Programming

DB2 Query -Convert multi values from column to rows

Hi Team I am using DB2 artisan tool and struck to handle multi values present in columns that are comma(,) separated. I want to convert those column values in separate rows . For example : Column 1 Column2 Jan,Feb Hold,Sell,Buy Expected Result Column1 ... (3 Replies)
Discussion started by: Perlbaby
3 Replies

LEARN ABOUT OPENSOLARIS

mlib_videocoloryuv444int_to_abgrint

mlib_VideoColorYUV444int_to_ABGRint(3MLIB)		    mediaLib Library Functions			mlib_VideoColorYUV444int_to_ABGRint(3MLIB)

NAME

       mlib_VideoColorYUV444int_to_ABGRint - color convert YUV interleaved to ABGR interleaved

SYNOPSIS

       cc [ flag... ] file... -lmlib [ library... ]
       #include <mlib.h>

       void mlib_VideoColorYUV444int_to_ABGRint(mlib_u32 *ABGR,
	    const mlib_u8 *YUV,const mlib_u8 *A_array, mlib_u8 A_const,
	    mlib_s32 w, mlib_s32 h, mlib_s32 dlb,
	    mlib_s32 slb, mlib_s32 alb);

DESCRIPTION

       The  YUV pixel stream is converted into an ABGR pixel stream. All pixel components are 8-bit unsigned integers. All buffers have dimensions
       w and h.

       The alpha values for this function work in the following fashion:

	   o	  If A_array pointer is not NULL, the values are taken from there. It has to have the same dimensions as the Y buffer.

	   o	  If A_array pointer is NULL, the alpha values for every pixel are set to A_const.

       The following equation is used:

	 |R|   |1.1644	0.0000	1.5966|   [|Y|	 | 16.0000|]
	 |G| = |1.1644 -0.3920 -0.8132| * [|U| - |128.0000|]
	 |B|   |1.1644	2.0184	0.0000|   [|V|	 |128.0000|]

PARAMETERS

       The function takes the following arguments:

       ABGR	  Pointer to output buffer.

       YUV	  Pointer to Y input buffer.

       A_array	  Array of alpha values.

       A_const	  Constant alpha value.

       w	  Image width in pixels.

       h	  Image height in lines.

       dlb	  Linebytes for output buffer.

       slb	  Linebytes for input buffer.

       alb	  Linebytes for alpha buffer.

RETURN VALUES

       None.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Committed 		   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |MT-Safe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       mlib_VideoColorYUV420seq_to_ARGBint(3MLIB),     mlib_VideoColorYUV411seq_to_ARGBint(3MLIB),     mlib_VideoColorYUV422seq_to_ARGBint(3MLIB),
       mlib_VideoColorYUV444seq_to_ARGBint(3MLIB),     mlib_VideoColorYUV420seq_to_ABGRint(3MLIB),     mlib_VideoColorYUV411seq_to_ABGRint(3MLIB),
       mlib_VideoColorYUV422seq_to_ABGRint(3MLIB),    mlib_VideoColorYUV444seq_to_ABGRint(3MLIB),     mlib_VideoColorYUYV422int_to_ARGBint(3MLIB),
       mlib_VideoColorYUV444int_to_ARGBint(3MLIB),    mlib_VideoColorYUYV422int_to_ABGRint(3MLIB),    mlib_VideoColorUYVY422int_to_ARGBint(3MLIB),
       mlib_VideoColorUYVY422int_to_ABGRint(3MLIB),    mlib_VideoColorUYV444int_to_ARGBint(3MLIB),     mlib_VideoColorUYV444int_to_ABGRint(3MLIB),
       attributes(5)

SunOS 5.11							    2 Mar 2007				mlib_VideoColorYUV444int_to_ABGRint(3MLIB)
All times are GMT -4. The time now is 09:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy