Select record having different value in second column
I want records which have more than one and different value in the second column on the below sample file.
Ex, I have the samle file below :-
I want to select XYZ and QWE line only.
Last edited by Scrutinizer; 05-17-2012 at 04:49 AM..
Reason: code tags
Hi,
I have a file with multiple records...and I have to select records based on first column....here is the sample file...
I01,abc,125,1a2,LBVI02
I01,abc,126,2b5,LBVI02
I02,20070530,254,abc,LLBI01
I02,20070820,111,bvd,NGBI01
I need all records with I01 in first field in one file and... (8 Replies)
I've a file like this:
andrea andre@lol.com october
antonio@lol.com
marco 45247@pop.com
kk@pop.com may
pollo@lol.com
mary mary@lol.com
can I select only the column with email adress?
can I utilise a filter with @ ?
I want obtain this:
... (2 Replies)
How can I use awk to pick a particular column and work on it? For example, I want to count the number of characters in column10 that are separated by |?
Thank you. (2 Replies)
the input is : 6298 | anna | chennai | 7/4/08
3981 | dastan | bagh | 8/2/07
6187 | galma | london | 9/5/01
3728 | gonna | kol | 8/2/10
3987 | hogja | mumbai | 8/5/09
2898 | homy | pune | 7/4/09
9167 | tamina | ny | 8/3/10
4617 | vazir | ny
now how to get the following output : 3987 |... (4 Replies)
Hi there,
I have trouble selecting record that contain one biggest value for a group of other values. I mean, this is my table:
mysql> SELECT * FROM b;
+----+------+-------+
| id | user | value |
+----+------+-------+
| 1 | 1 | 100 |
| 3 | 1 | 150 |
| 5 | 1 | 300 |
| 6... (20 Replies)
Hi!
From a file the format of whichis as in the sample here below, I need to get two files having just 2 columns, being - for the first file - the 2nd than the 1st from the original file; and - for the second file - the LAST then the 1st column of the original file.
Moreover, I would sort the... (3 Replies)
Hi All,
I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record.
For example, let's assume for column D... (9 Replies)
Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records
Table
---------
Col1 col2 col3 col4 ....................col20
1 2 3 4 .................... 20
a b c d .................... v
... (11 Replies)
Hello,
I want to get the maximum value of each record separated by empty line based on the 3rd column of each row within each record?
Input:
A1 chr5D 634 7 82 707
A2 chr5D 637 6 82 713
A3 chr5D 637 5 82 713
A4 chr5D 626 1 82 704... (4 Replies)
Discussion started by: yifangt
4 Replies
LEARN ABOUT SUNOS
mlib_imagecolorxyz2rgb_fp
mlib_ImageColorXYZ2RGB_Fp(3MLIB) mediaLib Library Functions mlib_ImageColorXYZ2RGB_Fp(3MLIB)NAME
mlib_ImageColorXYZ2RGB_Fp - XYZ to RGB color conversion
SYNOPSIS
cc [ flag... ] file... -lmlib [ library... ]
#include <mlib.h>
mlib_status mlib_ImageColorXYZ2RGB_Fp(mlib_image *dst, const mlib_image *src);
DESCRIPTION
The mlib_ImageColorXYZ2RGB_Fp() function performs a color space conversion from CIE XYZ to ITU-R Rec.708 RGB with D64 white point.
The source and destination images must be three-channel images.
It uses the following equation:
|R| |cmat[0] cmat[1] cmat[2]| |X|
|G| = |cmat[3] cmat[4] cmat[5]| * |Y|
|B| |cmat[6] cmat[7] cmat[8]| |Z|
where
cmat[] = { 3.240479, -1.537150, -0.498535,
-0.969256, 1.875992, 0.041566,
0.055648, -0.204043, 1.057311 };
src[x][y] = { X, Y, Z };
dst[x][y] = { R, G, B };
PARAMETERS
The function takes the following arguments:
dst Pointer to destination image.
src Pointer to source image.
RETURN VALUES
The function returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Interface Stability |Evolving |
+-----------------------------+-----------------------------+
|MT-Level |MT-Safe |
+-----------------------------+-----------------------------+
SEE ALSO mlib_ImageColorConvert1(3MLIB), mlib_ImageColorConvert1_Fp(3MLIB), mlib_ImageColorRGB2XYZ(3MLIB), mlib_ImageColorRGB2XYZ_Fp(3MLIB),
mlib_ImageColorRGB2YCC(3MLIB), mlib_ImageColorRGB2YCC_Fp(3MLIB), mlib_ImageColorXYZ2RGB(3MLIB), attributes(5)SunOS 5.10 10 Nov 2004 mlib_ImageColorXYZ2RGB_Fp(3MLIB)