I wanted to do a lookup table method using awk or any other commands. I would really appreciate any help on this. my sample input and desired outputs are given below. file1.txt is my lookuptable file, file2.txt, is the main file.
33.00
33.56
33.57
NaN
NaN
33.50
33.60
33.54
NaN
33.71
33.90
desired output
Code:
33.00 0.00000000000000 ; 33 < 33.5
33.56 0.041351
33.57 0.289457
NaN NaN
NaN NaN
33.50 0.00000000000000
33.60 0.41351002500000
33.54 0.165404
NaN NaN
33.71 0.41351002500000
33.90 0.41351002500000 ; 33.9 > 33.6
If the value in file2.txt is lower than that of the minimum in file1.txt, then it will use the corresponding value of the minimum in file1.txt and will use the maximum value in file2.txt, if it is otherwise.
Last edited by Scott; 01-19-2013 at 02:46 AM..
Reason: Fixed code tags
Hi,
I am new to awk and want to create a script that finds a string of text then prints the following table to a seperate file.
I thought of using the / / identifier, but how do I retrieve the next 15 lines?
gavin (6 Replies)
Hello,
I need some help to reformat this table-by-row to matrix?
infile:
site1 A:o,p,q,r,s,t
site1 C:y,u
site1 T:v,w
site1 -:x,z
site2 A:p,r,t,v,w,z
site2 C:u,y
site2 G:q,s
site2 -:o,x
site3 A:o,q,s,t,u,z
site3 C:y
site3 T:v,w,x
site3 -:p,routfile:
SITE o p q r s t v u w x y... (7 Replies)
Hi I am trying to create a table within an awk if statement
awk -F, '{ if ($8 ~ /Match/)
BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' SN1.csv | mailx -s "Your details" abc@123.com
But this doesnt work..
Please suggest (8 Replies)
I need to create one script in which I want to search in txt file , this txt file is having 10 columns , I want to check 4th column value if "BOY" & 10th column value =>500 it will print 4th column row value ,1st column row value & 10th column row value & store the same value in one file as... (2 Replies)
Hi everyone,
I would like to complete the following could you please find some time and help me to achieve below:
File 1 has a list of IP address (more than 1k)
File1:1.1.1.1
2.2.2.2
1.1.1.2
3.3.3.3
2.3.3.2File 2 has content like this:Internet 11.165.91.244 0 Incomplete ... (4 Replies)
I am trying to format the table below to the output
input:
cand week sub1 sub2 sub3 sub4
joe 1 94.19 70.99 43.93 60.14
joe 2 94.07 51.02 41.07 38.92
joe 3 26.24 30.95 44.56 67.67
joe 4 72.36 60.92 40.78 83.25
joe 5 51 70.01 44.66 82.22... (7 Replies)
Hi everyone,
Has anyone figured out yet how to do pivot table averages using AWK. I didn't see anything with regards to doing averages.
For example, suppose you have the following table with various individuals and their scores in round1 and round2:
SAMPLE SCORE1 SCORE2
British ... (6 Replies)
Discussion started by: Geneanalyst
6 Replies
LEARN ABOUT OSX
cexpf
CEXP(3) BSD Library Functions Manual CEXP(3)NAME
cexp -- complex exponential function
SYNOPSIS
#include <complex.h>
double complex
cexp(double complex z);
long double complex
cexpl(long double complex z);
float complex
cexpf(float complex z);
DESCRIPTION
cexp(z) returns the complex exponential of z.
cexp(conj(z)) = conj(cexp(z)), for all complex floating-point numbers z.
SPECIAL VALUES
The conjugate symmetry of cexp() is used to abbreviate the specification of special values.
cexp(+-0 + 0i) returns 1 + 0i.
cexp(x + inf i) returns NaN + NaN i, and raises the invalid flag, for finite x.
cexp(x + NaN i) returns NaN + NaN i, for finite x.
cexp(inf + 0i) returns inf + 0i.
For the following two cases, cis(y) denotes cos(y) + I*sin(y).
cexp(-inf + yi) returns 0*cis(y), for finite y.
cexp(inf + yi) returns inf*cis(y), for finite nonzero y.
cexp(-inf + inf i) returns -0 + 0i.
cexp(inf + inf i) returns -inf + NaN i, and raises the invalid flag.
cexp(-inf + NaN i) returns -0 + 0i.
cexp(inf + NaN i) returns -inf + NaN i.
cexp(NaN + 0i) returns NaN + 0i.
cexp(NaN + yi) returns NaN + NaN i for all nonzero numbers y.
cexp(NaN + NaN i) returns NaN + NaN i.
SEE ALSO exp(3)clog(3)complex(3)STANDARDS
The cexp() function conforms to ISO/IEC 9899:2011.
4th Berkeley Distribution December 11, 2006 4th Berkeley Distribution