Eino Uikkanen's homepage > Program E1FILTER > Evaluator's standard functions - updated 24.02.2008

Evaluator's standard functions

Function Number Class Description Syntax Remark
RND 1 num Rounded value RND:(numvalue;unit;u/d/n) default unit = 1, u/d/n = up, down, nearest, default = n
ABS 2 num Absolute value ABS:(numvalue)  
SGN 3 num Sign SGN:(numvalue)  
EXP 4 num Power of e (neper) EXP:(numvalue)  
LOG 5 num Natural logarithm LOG:(numvalue)  
MOD 6 num Modulus MOD:(numvalue;dividend)  
SQR 7 num Square root SQR:(numvalue)  
SUM 8 num Sum SUM:(list) Subject to change
MIN 9 num Minimum MIN:(list) Subject to change
MAX 10 num Maximum MAX:(list) Subject to change
F 11 num Format numeric value F:(numvalue;int.len;des.len;style) Style C = use comma as desimal separator
L 12 num Format integer value L:(numvalue;int.len;left fill character)  
SIN 13 trig Sine SIN:(radians)  
COS 14 trig Cosine COS:(radians)  
TAN 15 trig Tangent TAN:(radians)  
ASIN 16 trig Arcus sine ASIN:(numvalue)  
ACOS 17 trig Arcus cosine ACOS:(numvalue)  
ATN 18 trig Arcus tangent ATN:(numvalue)  
ATN2 19 trig Arcus tangent 2 ATN2:(numvalue1;numvalue2)  
SINH 20 trig Hyperbolic sine SINH:(numvalue)  
COSH 21 trig Hyperbolic cosine COSH:(numvalue)  
TANH 22 trig Hyperbolic tangent TANH:(numvalue)  
DEG 23 trig Degrees (from radians) DEG:(radians)  
RAD 24 trig Radians (from degrees) RAD:(degrees)  
PI 25 trig Pi PI:  
SPL 26 stredit Split string SPL:(separators;s/e;string) s=start block, e=end block
SST 27 stredit Substring SST:(string;startpos;endpos;r) r=from the right
TR 28 stredit Trim (trailing and leading spaces) TR:(string)  
TK 29 stredit Take character TK:(take-chars;string)  
DR 30 stredit Drop characters DR:(drop-chars;string;l/r) from the left, r=from the right
UC 31 stredit Upper Case UC:(string)  
LC 32 stredit Lower Case LC:(string)  
TC 33 stredit Title Case TC:(string)  
SC 34 stredit Sentence case SC:(string)  
INV 35 stredit String from end to start INV:(string)  
XOR 36 stredit String XORed 255 (for sort) XOR:(string)  
PACK 37 stredit Packed string PACK:(pack-chars;string)  
STPOS 38 strpos First string position STPOS:(search-string;string;startpos) Case sensitive
SPOS 39 strpos First some-character position SPOS:(search-chars;string;startpos) Case sensitive
NPOS 40 strpos First none-character position NPOS:(search-chars;string;startpos) Case sensitive
DPOS 41 strpos First difference position DPOS:(string1;string2) Case sensitive
A9POS 42 strpos A9-position A9POS:(A9-string;target-string;start-pos)  
A9STR 43 strgen Take A9-string A9STR:(A9-string;target-string;start-pos)  
STR 44 strgen String of characters/strings STR:(number;string)  
ADDRELE 45 strgen Address element ADDRELE:(lineseps;addr.elem;addresslines)  
REFNUM 46 strgen Bank reference number (FI) REFNUM(reference type;reference string)  
REPTXT 47 strgen Replace text in a sring REPTXT:(replace;with;string)  
TXTGRP 48 strgen Group characters in string TXTGRP:(string;separator;group-len;right-len)  
SEQ 49 test Strings are equal SEQ:(string1;string2)  
MATCH 50 test Strings match MATCH:(string;pattern)  
STIRG 51 test String in between min&max STIRG:(test-string;low-value;high-value)  
NRIRG 52 test Numeric value in between min&max NRIRG:(test-value;low-value;high-value)  
LENIRG 53 test String length is in the range LENIRG:(test-string;low-value;high-value)  
DATIRG 54 test Date is in the range DATIRG:(date;dateform;start-period;end-period)  
DATDIF 55 test Difference (in days) between two dates DATDIF:(date1,date2;dateform)  
JULIAN 56 other Julian dare JULIAN:(date;dateform)  
BL 57 test Is Blank (spaces,tab,lf) BL:(string)  
IF 58 logical If IF:(condition;true-value;false-value)  
NOT 59 logical Not NOT:(condition)  
ASC 60 other ASCII-code ASC:(string)  
LI 61 other List item LI:  
FV 62 other File value (FVALUE) FV:(value-file;test-value;key-column;separator;value-column;default-value)  
LEN 63 other Length of string LEN:(string)  
DAT 64 other Date DAT:(date;date-out form;date in-form)  
TIM 65 other Time TIM:(time;time-out form; time in-form)  
SET 66 listope List set SET:(listsep;list) Subject to change
UNION 67 listope List union UNION:(listsep;list1;list2) Subject to change
INTSEC 68 listope List intersection INTSEC:(listsep;list1;list2) Subject to change
COMPL 69 listope List complement COMPL:(listsep;list1;list2) Subject to change
LLEN 70 listope List lenght (number of items) LLEN:(listsep;list) Subject to change
LTEM 71 listope List item LTEM:(listsep;itemnum;list)  
CCNV 72 geodetic Geodetic coordinate conversion See GeodeticFunctions.pdf  
DIST 73 geodetic Distance between two points See GeodeticFunctions.pdf  
BEAR 74 geodetic Bearing between two points See GeodeticFunctions.pdf  

Program E1FILTER