Right$
right$ extracts a substring of a string starting from a given position (the right side).
right$(EXPR_STRING,EXPR_POS)
EXPR_STRING is an expression that gives the string from which the substring is extracted.EXPR_POS gives the position where the extraction starts. # Extraction of the letters starting from 12th position of the latin alphabet
ALPHABET = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
AFTER_TWELVE=right$(ALPHABET, 12) : # Returns "LMNOPQRSTUVWXYZ"
# Computes the length of a string
# It would be preferable to use len!!!
STRING_LEN = 0
While right$(MY_STRING,STRING_LEN+1) <> "" : STRING_LEN+=1 : Wend
# Extracts the character from a string starting at position 32
# the result string will become an empty string if its original length was smaller than 32
MY_STRING=right$(MY_STRING,32)
# Extracts the characters from a clob starting at position 800
# the clob will become an empty string if its original length was smaller than 800
MY_CLOB=right$(MY_CLOB,800)
The function right$ extracts the characters of a string, starting at EXPR_POS position. Based on the length of the result, the type of the result is Char or Clbfile.
EXPR_POS is equal to 0 or 1, the whole string is returned.EXPR_POS is greater than the length of the string, the null string "" is returned.| Error code | Description |
|---|---|
| 10 | The first argument is not a string, or the second argument is not numeric. |
| 50 | The second argument is negative. |