next up previous contents index
Next: 7.11.5 Logic Functions Up: 7.11 Quick-Reference Guide to Previous: 7.11.3 Conditional Statistical Functions

7.11.4 String 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 up previous contents index
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