How to split one long column into multiple rows with 3 each ?
I have a large csv dataset like this :
what I expected output is :
I'm thinking of use like awk, columns , but haven't find a proper way to do that.
could anyone give me some clues?
i have single column which is starting with same string(many number of rows)
i have to convert each into a single row.how can i do that?
laknar
std
mes
23
55
laknar
isd
phone no
address
amount
99
I have to convert above like below.
laknar|std|mes|23|55
laknar|isd|phone... (3 Replies)
hey guys...
Im looking to do the following:
1
2
3
4
5
6
7
8
9
Change to:
1 4 7
2 5 8
3 6 9
Did use | perl -lpe'$\=$.%3?$":"\n"' , but it doesnt give me the matrix i want. (3 Replies)
Hi all,
I need to convert this file having just one column into two column file
current file:
a
15
b
21
c
34
d
48
e
10
wanted:
a 15
b 21
c 34 (15 Replies)
Hello Friends,
I am trying to implement the following using UNIX. I am getting a sequential file as input which would have two columns, "Name" and "Countries Visited". The "Countries Visisted" field will be multi-valued, each value separated by a space and also the number of values are not... (2 Replies)
Hi pls help me out to short out this problem
rm PAB113_011.out
rm: PAB113_011.out: override protection 644 (yes/no)? n
If i give y it remove the file.
But i added the rm command as a part of ksh file and i tried to remove the file. Its not removing and the the file prompting as... (7 Replies)
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)
Hi,
I have input dataset as below:
Cl.jenn,1051,ABCD
JEN.HEA,9740|1517|8119|2145,ZZZZ,REPEAT
Rich.Sm,
Ann.Car,3972|4051|1064|4323|4122|2394|2574|4507
Sta.for,7777,ABCD,UUUU
Sm.Ric,
Ch.LRD,
Eh.ab,
Gr.sh,
Expected output:
-------------------
Cl.jenn,1051,ABCD... (6 Replies)
Discussion started by: saravananravim
6 Replies
LEARN ABOUT DEBIAN
qwtscalearithmetic
QwtScaleArithmetic(3) Qwt User's Guide QwtScaleArithmetic(3)NAME
QwtScaleArithmetic -
Arithmetic including a tolerance.
SYNOPSIS
#include <qwt_scale_engine.h>
Static Public Member Functions
static double ceil125 (double x)
static double ceilEps (double value, double intervalSize)
static int compareEps (double value1, double value2, double intervalSize)
static double divideEps (double interval, double steps)
static double floor125 (double x)
static double floorEps (double value, double intervalSize)
Detailed Description
Arithmetic including a tolerance.
Member Function Documentation
double QwtScaleArithmetic::ceil125 (doublex) [static] Find the smallest value out of {1,2,5}*10^n with an integer number n which is greater
than or equal to x
Parameters:
x Input value
double QwtScaleArithmetic::ceilEps (doublevalue, doubleintervalSize) [static] Ceil a value, relative to an interval
Parameters:
value Value to ceil
intervalSize Interval size
See also:
floorEps()
int QwtScaleArithmetic::compareEps (doublevalue1, doublevalue2, doubleintervalSize) [static]
Compare 2 values, relative to an interval. Values are 'equal', when : $
Parameters:
value1 First value to compare
value2 Second value to compare
intervalSize interval size
Returns:
0: if equal, -1: if value2 > value1, 1: if value1 > value2
double QwtScaleArithmetic::divideEps (doubleintervalSize, doublenumSteps) [static]
Divide an interval into steps. $stepSize = (intervalSize - intervalSize * 10e^{-6}) / numSteps$.PP Parameters:
intervalSize Interval size
numSteps Number of steps
Returns:
Step size
double QwtScaleArithmetic::floor125 (doublex) [static]
Find the largest value out of {1,2,5}*10^n with an integer number n which is smaller than or equal to x. Parameters:
x Input value
double QwtScaleArithmetic::floorEps (doublevalue, doubleintervalSize) [static] Floor a value, relative to an interval
Parameters:
value Value to floor
intervalSize Interval size
See also:
floorEps()
Author
Generated automatically by Doxygen for Qwt User's Guide from the source code.
Version 5.2.2 Mon Aug 1 2011 QwtScaleArithmetic(3)