08-04-2011
Rename a header column by adding another column entry to the header column name
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
That is to say, the Signal header becomes Signal-CSCH74_1_1 using the 1st column entry.
Please help me urgently!!
Thanks
Last edited by Vavad; 08-05-2011 at 12:19 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
$ cat log.txt
Name Age Sex Lcation nfld alias xsd
CC 25 M XYZ asx KK Y
BB 21 F XAS awe SS N
SD 21 M AQW rty SD A
How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column?
so that the final output will become:
Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies
2. Shell Programming and Scripting
i have a script that access the database and then returns some row. but in the command prompt it it not showing the column header. how to get that ?
below the script:
------------------------------------------------------------------------
#!/bin/ksh
.... (4 Replies)
Discussion started by: ali560045
4 Replies
3. Shell Programming and Scripting
Hello all,
We are trying to run a script in Oracle DB from AIX.
We need to set the Column Header while executing the query to generate the Output.
For eg.
select city, name from emp;
It need to generate report in .csv format as
CITY NAME
atla tom
cincin jack
How I... (1 Reply)
Discussion started by: velappangs
1 Replies
4. Shell Programming and Scripting
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies
5. Shell Programming and Scripting
Hi,
I have an input like this
1 2 3 4
2 3 4 5
4 5 6 7
I would like to count the no. of columns and print a header with a prefix "Col".
I would also like to count the no. of rows and print as first column with each line number with a prefix "Row"
So, my output would be
... (2 Replies)
Discussion started by: jacobs.smith
2 Replies
6. Shell Programming and Scripting
Hi,
I have some 10 tab delimited flat files, for some files the column header starts from 1st row whereas for some other files the column header starts from row or row 3 or row4 and so on....
Is there any way in UNIX so that we can read the column headers dynamically.'
I am new to UNIX, so... (12 Replies)
Discussion started by: kedar_laveti
12 Replies
7. Shell Programming and Scripting
Hi,
Below is the data in a tab limited file
Here ACCENT is just a heading and the line starting with Pcode has the column headers, and there is a 2 lines space between the file header and column header.
I want to print $2, that is Dealer Name
I used the below code
nawk... (1 Reply)
Discussion started by: kedar_laveti
1 Replies
8. Shell Programming and Scripting
hello,
can someone helpe me on below issue.
i have a list of names and IDs,
mick 3424
noah 134
samuel 787
jack 434
i want to add a head for both colum using awk or sed or any tool
output
NAME ID
mick 3424
noah 134
samuel 787 (10 Replies)
Discussion started by: Sara_84
10 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have a txt file with multiple columns and i want to substitute the header of the first column.
Example:
Seq. Name Seq. Length #Hits min. eValue mean Similarity #GOs GOs Enzyme Codes InterProScan
comp1000201_c0_seq1 ---NA--- 337 0 0 -
comp1000297_c0_seq1 ---NA--- 612 0 0 -... (4 Replies)
Discussion started by: alisrpp
4 Replies
10. Shell Programming and Scripting
Hello,
I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically
I/p
c1,c2,c3,c4,c5
10,20,30,40,50
20,30,40,50,60
If i want to find sum only column c1, c3 and output it as c6,c7
O/p
c1,c2,c3,c4,c5,c6,c7
10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies
LEARN ABOUT OPENSOLARIS
mlib_imagecolorrgb2ycc
mlib_ImageColorRGB2YCC(3MLIB) mediaLib Library Functions mlib_ImageColorRGB2YCC(3MLIB)
NAME
mlib_ImageColorRGB2YCC - RGB to YCC color conversion
SYNOPSIS
cc [ flag... ] file... -lmlib [ library... ]
#include <mlib.h>
mlib_status mlib_ImageColorRGB2YCC(mlib_image *dst, const mlib_image *src);
DESCRIPTION
The mlib_ImageColorRGB2YCC() function performs a color space conversion from computer R'G'B' to ITU-R Rec.601 Y'CbCr.
The source and destination images must be three-channel images.
It uses the following equation:
|Y'| |cmat[0] cmat[1] cmat[2]| |R'| |offset[0]|
|Cb| = |cmat[3] cmat[4] cmat[5]| * |G'| + |offset[1]|
|Cr| |cmat[6] cmat[7] cmat[8]| |B'| |offset[2]|
where
cmat[] = { 65.738/256, 129.057/256, 25.064/256,
-37.945/256, -74.494/256, 112.439/256,
112.439/256, -94.154/256, -18.285/256 };
offset[] = { 16, 128, 128 };
src[x][y] = { R', G', B' };
dst[x][y] = { Y', Cb, Cr };
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 |Committed |
+-----------------------------+-----------------------------+
|MT-Level |MT-Safe |
+-----------------------------+-----------------------------+
SEE ALSO
mlib_ImageColorConvert2(3MLIB), mlib_ImageColorConvert2_Fp(3MLIB), mlib_ImageColorRGB2YCC_Fp(3MLIB), mlib_ImageColorXYZ2RGB(3MLIB),
mlib_ImageColorXYZ2RGB_Fp(3MLIB), mlib_ImageColorYCC2RGB(3MLIB), mlib_ImageColorYCC2RGB_Fp(3MLIB), attributes(5)
SunOS 5.11 2 Mar 2007 mlib_ImageColorRGB2YCC(3MLIB)