With this option s selection of values can be transformed using a regular expression (see figure 1).
figure 1: Apply Transformation window
A regular expression can be composed using the following elements:
VARIABLES
The variables that can be used to compose an expression are the alphabetical indexes of columns. These can be found in the coloured area of the column headers (see figure 2) and are case sensitive.
figure 2: Alphabetical column indices
OPERATORS
add |
+ |
subtract |
- |
multiply |
* |
divide |
/ |
power |
^ |
FUNCTIONS
function |
description |
example |
---|---|---|
sum |
sum of values |
sum(A,B,...) |
abs |
absolute value |
abs(A) |
pow |
power function |
pow(A,2) |
sqrt |
square root |
sqrt(B) |
min |
minimum of list |
min(A,B,C) |
max |
maximum of list |
max(A,B,C) |
average |
average of list |
average(A,B,C) |
exp |
exponential (e^x) |
exp(A) |
ln |
natural logarithm |
ln(A) |
log |
logarithm base 10 |
log(A) |
atanh |
inverse hyperbolic tangent |
atanh(A) |
acosh |
inverse hyperbolic cosine |
acosh(A) |
asinh |
inverse hyperbolic sine |
asinh(A) |
tanh |
||
cosh |
||
sinh |
||
atan |
||
acos |
||
asin |
||
tan |
||
cos |
||
sin |