01-22-2009
Quote:
Originally Posted by
vgersh99
it doesn't look like your 'input' file has '|' separated fields.
does the 'ColA' and 'ColB' headers actually exist in the 'input' file?
sorry for the wrong file
Input file:
ColA ColB
1|2
2|x
3|y
4|c
5|q
and it doesnt have column header.
thanks johnson for the approach, but it will try to read the file line by line, which i want to avoid. since in production i may have millions of records and this may cause a bottleneck.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a table in Db2 with data say
id_1 phase1
id_1 phase2
id_1 phase3
id_2 phase1
id_2 phase2
I need to concatenate the values like
id_1 phase1,phase2,phase3
id_2 phase1,phase2
I tried recursive query but in vain as the length of string to be concatenated in quite long. ... (17 Replies)
Discussion started by: jsaravana
17 Replies
2. Shell Programming and Scripting
Hi All,
I needd to convert values in a row to a column.
eg: Input is as: value1,value2,value3,value4,.........,value N
Required Output:
Value1
Value2
Value3
.
.
.
Value N
Please help.... (3 Replies)
Discussion started by: sambaman
3 Replies
3. UNIX for Advanced & Expert Users
Hi all I have a file as below :
Development
System
User
Production
i want to convert the file to below format:
"Development","System","User","Production"
Is it possible with UNIX ? if so can you please give me some direction on it ?
Thanks,
Satya
Use code tags please, ty. (10 Replies)
Discussion started by: satyaranjon
10 Replies
4. Shell Programming and Scripting
Can somebody help me in solving this..
Input data is like
0 A
1 B
2 C
3 D
0 A1
1 B1
2 C1
3 D1
0 A2
1 B2
2 C2
3 D2
Output should be like
A B C D
A1 B1 C1 D1
A2 B2 C2 D2 (7 Replies)
Discussion started by: Mahantesh Patil
7 Replies
5. Shell Programming and Scripting
Hi everyone..
I have a list of values in a file...
1.2345e-1
2.282828e+
3.2341e-1
1.1223445e-1
I am interested in converting this column to a row..
1.2345e-1 2.282828e+ 3.2341e-1 1.1223445e-1
can anyone pls help?? I am a liunx newbie..
Thanks.. (7 Replies)
Discussion started by: kjha
7 Replies
6. Shell Programming and Scripting
Hi Friends,
I have a single column data like below.
1
2
3
4
5
I need the output like below.
0
1
2
3
4
where each row (including first row) subtracting from first row and the result should print below like the way shown in output file.
Thanks
Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies
7. Shell Programming and Scripting
Hello All,
I have a below data in a .csv file where all rows where col1 is A, col2 is odd numbers, similarly even numbers for all rows where col1 is B.
Note that my data has some other columns(not shown here) too (around 100) after col2.
Tool,Data
A,1
A,3
A,5
....
so on
B,2
B,4
.... ... (4 Replies)
Discussion started by: ks_reddy
4 Replies
8. Shell Programming and Scripting
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)
Discussion started by: AK47
6 Replies
9. Shell Programming and Scripting
Hi,
I want to convert a single row values to multiple rows, but the no. of rows are not fixed.
For example, I have a row as below
abc-def-lmn-mno-xyz
out put should be
get abc
get def
get lmn
get xyz (4 Replies)
Discussion started by: Suneel Mekala
4 Replies
10. Shell Programming and Scripting
I want to bring values in the second column into single line for uniq value in the first column.
My input
jvm01, Web 2.0 Feature Pack Library
jvm01, IBM WebSphere JAX-RS
jvm01, Custom01 Shared Library
jvm02, Web 2.0 Feature Pack Library
jvm02, IBM WebSphere JAX-RS
jvm03, Web 2.0 Feature... (10 Replies)
Discussion started by: kchinnam
10 Replies
LEARN ABOUT MINIX
tabfunc
TABFUNC(1) General Commands Manual TABFUNC(1)
NAME
tabfunc - convert table to functions for rcalc, etc.
SYNOPSIS
tabfunc [ -i ] func1 [func2 ..]
DESCRIPTION
Tabfunc reads a table of numbers from the standard input and converts it to an expression suitable for icalc(1), rcalc(1) and their
cousins. The input must consist of a M x N matrix of real numbers, with exactly one row per line. The number of columns must always be
the same in each line, separated by whitespace and/or commas, with no missing values. The first column is always the independent variable,
whose value indexes all of the other elements. This value does not need to be evenly spaced, but it must be either monotonically increas-
ing or monotonically decreasing. (I.e. it cannot go up and then down, or down and then up.) Maximum input line width is 4096 characters
and the maximum number of data rows is 1024. Input lines not beginning with a numerical value will be silently ignored.
The command-line arguments given to tabfunc are the names to be assigned to each column. Tabfunc then produces a single function for each
column given. If there are some columns which should be skipped, the dummy name "0" may be given instead of a valid identifier. (It is
not necessary to specify a dummy name for extra columns at the end of the matrix.)
The -i option causes tabfunc to produce a description that will interpolate values in between those given for the independent variable on
the input.
EXAMPLE
To convert a small data table and feed it to rcalc for some calculation:
rcalc -e `tabfunc f1 f2 < table.dat` -f com.cal
AUTHOR
Greg Ward
SEE ALSO
cnt(1), icalc(1), neaten(1), rcalc(1), rlam(1), total(1)
RADIANCE
10/8/97 TABFUNC(1)