Dear Unix Gurus,
I have a sample data set that looks like this
y1 y2 y3 y4 y5
x1 0.3 0.5 2.3 3.1 5.1
x2 1.2 4.1 3.5 1.7 1.2
x3 3.1 2.1 1.0 4.1 2.1
x4 5.0 4.0 6.0 7.0 1.1
I want to open it up so that I get
x1 y1 0.3
x2 y1 1.2
x3 y1 3.1
x4 y1 5.0
x1 y2 0.5
x2 y2... (3 Replies)
Hi
I want to convert multiple rows ro single row ,I have tried with below one but I am not getting what I am expecting.Please any idea
a.txt
conn1=stg
conn2=dev
path=\xxx\a1.txt
fre=a
conn1=stg
conn2=dev
path=\xxx\a2.txt
freq=a
awk '/a/{ORS=" "}{print}END{print "\n"}'... (5 Replies)
hi,
I have a requirement where in I read the values from a file using awk. The resulting data should be converted into row format from column format.
For ex: My log file login.lst contains the following
SERVER1 DB1
SERVER2 DB2
SERVER3 DB3
SERVER4 DB4
I use awk to grep only the server... (6 Replies)
Hello all
I have data like
1
2
3
4
5
I wish my output would be like
1,2,3,4,5
For this i have executed
'BEGIN {FS="\n"; ORS=","} {print $0}' test
and got the output as
1,2,3,4,5,
I do not want to have , at the end of 5. output should be like (5 Replies)
Hi,
I have a file like this
50 1 2 1374438
50 1 2 1682957
50 5 2 1453574
50 10 2 1985890
100 1 2 737307
100 5 2 1660204
100 10 2 2148483
and I want to convert this by... (1 Reply)
Hi All,
I am looking for some help to convert a csv with IP ranges in.. in the format e.g.
1.1.1.2, 1.1.1.5
2.1.1.10, 2.1.1.20
and would be looking to output as follows:
1.1.1.2
1.1.1.3
1.1.1.4
1.1.1.5
2.1.1.10
2.1.1.11
etc etc up to 2.1.1.20
I have tried a few google... (4 Replies)
Discussion started by: zippyzip
4 Replies
LEARN ABOUT DEBIAN
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)