Next: 7.11.5 Logic Functions
Up: 7.11 Quick-Reference Guide to
Previous: 7.11.3 Conditional Statistical Functions
- @CHAR(N) -
- The character represented by the code N.
- @CLEAN(S) -
- The string formed by removing all non-printing
characters from the string S.
- @CODE(S) -
- The ASCII code for the first character in
string S.
- @EXACT(S1, S2) -
- Returns true (1) if string S1
exactly matches string S2, otherwise returns 0.
- @FIND(S1, S2, N) -
- The index of the first occurrence of
S1 in S2.
- @FORMAT(F, N, X) -
- The string formed by formatting the
value X using format code F and precision
N.
- @HEXTONUM(S) -
- The numeric value for the hexadecimal
interpretation of S.
- @LEFT(S, N) -
- The string composed of the leftmost N
characters of S.
- @LENGTH(S) -
- The number of characters in S.
- @LOWER(S) -
- S converted to lower case.
- @MID(S, N1, N2) -
- The string of length N2 that
starts at position N1 in S.
- @NUMTOHEX(X) -
- The hexadecimal representation of the
integer portion of X.
- @PROPER(S) -
- The string S with the first letter of
each word capitalized.
- @REGEX(S1, S2) -
- Returns true (1) if string S1
exactly matches string S2; otherwise returns
false (0). Allows ``wildcard'' comparisons by
interpreting S1 as a regular expression.
- @REPEAT(S, N) -
- The string S repeated N times.
- @REPLACE(S1, N1, N2, S2) -
- The string formed by replacing the
N2 characters starting at position N1 in
S1 with string S2.
- @RIGHT(S, N) -
- The string composed of the rightmost
N characters of S.
- @STRCAT(...) -
- The concatenation of all its arguments.
- @STRING(X, N) -
- The string representing the numeric value
of X, to N decimal places.
- @STRLEN(...) -
- The total length of all strings in its
arguments.
- @TRIM(S) -
- The string formed by removing spaces from the
string S.
- @UPPER(S) -
- The string S converted to upper case.
- @VALUE(S) -
- The numeric value represented by the string
S; otherwise 0 if S does not represent a number.
Next: 7.11.5 Logic Functions
Up: 7.11 Quick-Reference Guide to
Previous: 7.11.3 Conditional Statistical Functions
NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999