05-05-2015
Thanks for the reply!
There is no need to modify the commas if the second awk statement could split the lines on the pipe characters.
The <newline> should be replaced by a single space.
Fields 1, 2, and 3 are numeric fields, so they never have <newline> characters.
Field 5 is a text field and can have <newline> characters incorrectly inserted.
Yes, fields 4 and 5 can each have multiple <newline> characters.
Thanks!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have an input data file :-
Test4599,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,2,2,Rain
Test90,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,Not Rain
etc....
I wanted to transpose these data to:-... (2 Replies)
Discussion started by: ahjiefreak
2 Replies
2. Shell Programming and Scripting
Hi.
I have this data below:-
v1 28 14 1.72414 1.72414 1.72414 1.72414 1.72414
v2 77 7 7.47126 6.89655 6.89655 6.89655 6.89655
v3 156 3 21.2644 21.2644 20.6897 21.2644 20.6897
v4 39 3 1.72414 1.72414 1.72414 1.72414 1.72414
v5 155 1 21.2644 23.5632 24.1379 23.5632 24.1379
v6 62 2 2.87356... (2 Replies)
Discussion started by: ahjiefreak
2 Replies
3. Shell Programming and Scripting
Hi,
I did read a few posts on the subjects, tried out a few solutions, but did not solve my problem.
https://www.unix.com/302121568-post11.html
https://www.unix.com/shell-programming-scripting/137953-large-file-columns-into-rows-etc-4.html
Please help. Problem very similar to the second link... (15 Replies)
Discussion started by: genehunter
15 Replies
4. Shell Programming and Scripting
Hi I'm looking to transpose Linux data from a daily report that logs every 10mins like below.
After the first "comma" I need the daily total for Col2 and Col3 transposed like below.
The new transposed format below will then be exported to Microsoft Excel for Reporting.
Any help would be... (9 Replies)
Discussion started by: ravzter
9 Replies
5. Shell Programming and Scripting
Hello. very new to shell scripting and would like to know if anyone could help me.
I have data thats being pulled into a txt file and currently have to manually transpose the data which is taking a long time to do.
here is what the data looks like.
Server1 -- Date -- Other -- value... (7 Replies)
Discussion started by: Mikes88
7 Replies
6. Shell Programming and Scripting
I can no longer find my commands, but I use to be able to transpose data with common fields from a single column to rows using a command line. My data is separated as follows:
NAME=BOB
ADDRESS=COLORADO
PET=CAT
NAME=SUSAN
ADDRESS=TEXAS
PET=BIRD
NAME=TOM
ADDRESS=UTAH
PET=DOG
I would... (7 Replies)
Discussion started by: docdave78
7 Replies
7. Shell Programming and Scripting
Hi I have below requirement, need help
One file contains the meta data information and other file would have the data, match the column from file1 and with file2 and extract corresponding column value and display in another file
File1:
CUSTTYPECD
COSTCENTER
FNAME
LNAME
SERVICELVL
... (1 Reply)
Discussion started by: ravlapo
1 Replies
8. Shell Programming and Scripting
Hi,
Below is my input file:
c116_g1_i1 -,-,-,+
c118_g2_i1 +,+
c118_g3_i1 +
c120_g1_i1 +,+,+,+
.
.
Desired Output File
c116_g1_i1 -
c116_g1_i1 -
c116_g1_i1 -
c116_g1_i1 +
c118_g2_i1 +
c118_g2_i1 + (3 Replies)
Discussion started by: perl_beginner
3 Replies
9. UNIX for Beginners Questions & Answers
Hi All,
I have sort of a case to transpose data from rows to column
input data
Afghanistan|10000|1
Albania|25000|4
Algeria|25000|7
Andorra|10000|4
Angola|25000|47
Antigua and Barbuda|25000|23
Argentina|5000|3
Armenia|100000|12
Aruba|20000|2
Australia|50000|2
I need to transpose... (3 Replies)
Discussion started by: radius
3 Replies
10. UNIX for Beginners Questions & Answers
Hi
I have the following sample of data: my full data dimention is 900,000* 1119
rs987435 C G 1 1 1 0 2
rs345783 C G 0 0 1 0 0
rs955894 G T 1 1 2 2 1
rs6088791 ... (7 Replies)
Discussion started by: marwah
7 Replies
LEARN ABOUT DEBIAN
dtk_create_triangle
DTK_CREATE_TRIANGLE(3) Draw Toolkit manual DTK_CREATE_TRIANGLE(3)
NAME
dtk_create_triangle - Create and modify triangle shape
SYNOPSIS
#include <drawtk.h>
dtk_hshape dtk_create_triangle(dtk_hshape shp,
float x1, float y1,
float x2, float y2,
float x3, float y3,
int filled, const float *color);
DESCRIPTION
dtk_create_triangle() creates a triangle between the vertices (x1,y1), (x2,y2) and (x3,y3).
shp, filled and color have the same usage and meaning as for other shape creation function:
* shp can be used to modify a previously created shape. If it is non-null, the handle will be used to modify the shape referenced by shp:
no new shape is created and the returned value is ensured to be shp in case of success, NULL otherwise. If shp is NULL, the function
will attempt to create a new shape.
* filled is set to 0 if the described shape should be a continuous line or a non-null value if the shape is supposed to be filled polygon.
* color should point to a 4 float array containing a normalized RGBA value (i.e. each component is between 0.0 and 1.0).
RETURN VALUE
In case of success these functions return the handle to the newly created or modified shape. If the shp argument is non-null, the handle
returned is the same value. In case of error, NULL is returned.
SEE ALSO
dtk_destroy_shape(3)
EPFL
2011 DTK_CREATE_TRIANGLE(3)