10-27-2016
Column to Row base on first and second Column
Input :-
Column to Row
Code :
Time CT 1 2 3
17:45 X 10 15 20
18:00 X 15 20 30
18:15 X 10 10 10
18:30 X 5 5 5
17:45 Y 10 15 20
18:00 Y 15 20 30
18:15 Y 10 10 10
18:30 Y 5 5 5
output:-
Code :
Time P X Y
17:45 1 10 10
18:00 1 15 15
18:15 1 10 10
18:30 1 5 5
17:45 2 15 15
18:00 2 20 20
18:15 2 10 10
18:30 2 5 5
17:45 3 15 15
18:00 3 20 20
18:15 3 10 10
18:30 3 5 5
I have tried below code :- but no luck
Code :
perl -ane 'BEGIN{$lc=0;} if ($lc==0) {@r=@F;$lc++;} else {for $i (1 .. $#r) {print "$F[0]\t$r[$i]\t$F[$i]\n";}$lc=0;@r=();}' T2.csv
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear friends,
Below is my program and current output. I wish to have 3 or 4 column output in order to accomodate in single page. i do have subsequent command to process after user enter the number.
Program
COUNT=1
for MYDIR in `ls /`
do
VOBS=${MYDIR}
echo "${COUNT}. ${MYDIR}"
... (4 Replies)
Discussion started by: baluchen
4 Replies
2. Shell Programming and Scripting
Hello,
I have an input file like the following:
11_3_4
2_1_35
3_15__
_16989
Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Discussion started by: jl487
2 Replies
3. Shell Programming and Scripting
Input file A.txt :-
C2062 -117.6 -118.5 -117.5
C5145 0 0 0
C5696 0 0 0
Output file B.txt
C2062 X -117.6
C2062 Y -118.5
C2062 Z -117.5... (4 Replies)
Discussion started by: asavaliya
4 Replies
4. Shell Programming and Scripting
Hi Guys,
Input.txt
L194 A -118.2
L194 B -115.1
L194 C -118.7
L196 A 0
L196 C 0
L197 A -111.2
L197 B -118.9
L197 C -119.9
L199 A -120.4
L199 B -119.9 ... (2 Replies)
Discussion started by: asavaliya
2 Replies
5. UNIX for Dummies Questions & Answers
file with this content
awk 'NR==1 {print $4} && NR==2 {print $5}' file
The error is shown with syntax error; what can be done (4 Replies)
Discussion started by: cdfd123
4 Replies
6. Shell Programming and Scripting
Hi,
I have the following file,
chr1 100 200 20
chr1 201 300 22
chr1 220 345 23
chr1 230 456 33.5
chr1 243 567 90
chr1 345 600 20
chr1 430 619 21.78
chr1 870 910 112.3
chr1 914 920 12
chr1 930 999 13
My output would be
peak1 20 22 23 33.5 90
peak2 20 21.78 112.3 12 13
Here the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies
7. Shell Programming and Scripting
HI Guys,
I have input file A.txt
1 AAA
1 BBB
1 1SW
1 2SW
1 3SW
1 BBB
1 PPP
1 1SW
1 PPP
1 1WS
1 1AS
1 P1P
1 AAA (1 Reply)
Discussion started by: pareshkp
1 Replies
8. Shell Programming and Scripting
HI Guys,
I want add one extra Column base on 3rd Column .
Input :-
M204 MS204_154 :vsDataUeMe
M204 MS204_154 es:sMeasure 0
M204 MS204_154 es:90ilterCoe 9
M204 MS204_154 es:searchE9090ortTime 40
M204 MS204_154 es:servOrPrioI90HoTimer 4000
M204 MS204_154 es:ueMeajllls154545 TRUE... (5 Replies)
Discussion started by: pareshkp
5 Replies
9. Shell Programming and Scripting
I have a table with this structure:
cola colb colc
1 19 lemon
20 31 lemon
32 100 lemon
159 205 cherries
210 500 cherries
and need to parse it into this format:
cola colb colc
1 100 lemon
159 500 cherries
So I need the first row of cola and the last row of colb if colc has the... (3 Replies)
Discussion started by: coppuca
3 Replies
10. UNIX for Beginners Questions & Answers
Hi all,
I have searched and searched, but I have not found a solution that quite fits what I am trying to do.
I have a long list of data in three columns. Below is a sample:
1,10,8
2,12,10
3,13,12
4,14,14
5,15,16
6,16,18
Please use code tags
What I need to do is as follows: If a... (4 Replies)
Discussion started by: bleedingturnip
4 Replies
LEARN ABOUT DEBIAN
aa_render
aa_render(3) Library Functions Manual aa_render(3)
NAME
aa_render - convert image buffer to ASCII-art.
SYNOPSIS
#include <aalib.h>
void aa_render
(
aa_context *c,
const aa_renderparams *p,
int x1,
int y1,
int x2,
int y2
);
PARAMETERS
aa_context *c
Specifies the AA-lib context to operate on.
const aa_renderparams *p
Rendering parametters used to specify brightness, gamma correction and other usefull stuff. Use aa_defrenderparams for default val-
ues.
int x1 Column of top left coner of rendered area (in characters!).
int y1 Row of top left coner of rendered area.
int x2 Column of bottom right coner of rendered area.
int y2 Row of bottom right coner of rendered area.
DESCRIPTION
This function does the trick of converting the emulated framebuffer into high quality ASCII-art. If you want to be really fast, you might
use aa_fastrender. If you want to emulate palette, use aa_renderpalette.
Note that to see the effect you need to call aa_flush too.
First call to this function may take a while, because the rendering tables are produced.
SEE ALSO
save_d(3) , mem_d(3) , aa_help(3) , aa_formats(3) , aa_fonts(3) , aa_dithernames(3) , aa_drivers(3) , aa_kbddrivers(3) , aa_mousedrivers(3) ,
aa_kbdrecommended(3) , aa_mouserecommended(3) , aa_displayrecommended(3) , aa_defparams(3) , aa_defrenderparams(3) , aa_scrwidth(3) ,
aa_scrheight(3) , aa_mmwidth(3) , aa_mmheight(3) , aa_imgwidth(3) , aa_imgheight(3) , aa_image(3) , aa_text(3) , aa_attrs(3) , aa_currentfont(3) ,
aa_autoinit(3) , aa_autoinitkbd(3) , aa_autoinitmouse(3) , aa_recommendhi(3) , aa_recommendlow(3) , aa_init(3) , aa_initkbd(3) , aa_initmouse(3) ,
aa_close(3) , aa_uninitkbd(3) , aa_uninitmouse(3) , aa_fastrender(3) , aa_puts(3) , aa_printf(3) , aa_gotoxy(3) , aa_hidecursor(3) , aa_showcur-
sor(3) , aa_getmouse(3) , aa_hidemouse(3) , aa_showmouse(3) , aa_registerfont(3) , aa_setsupported(3) , aa_setfont(3) , aa_getevent(3) ,
aa_getkey(3) , aa_resize(3) , aa_resizehandler(3) , aa_parseoptions(3) , aa_edit(3) , aa_createedit(3) , aa_editkey(3) , aa_putpixel(3) , aa_recom-
mendhikbd(3) , aa_recommendlowkbd(3) , aa_recommendhimouse(3) , aa_recommendlowmouse(3) , aa_recommendhidisplay(3) , aa_recommendlowdisplay(3)
c2man aalib.h 8 September 1999 aa_render(3)