Right$

right$ extracts a substring of a string starting from a given position (the right side).

Syntax

 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.

Examples

 # Extraction of the letters starting from 12th position of the latin alphabetALPHABET = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"AFTER_TWELVE=right$(ALPHABET, 12) : # Returns "LMNOPQRSTUVWXYZ"# Computes the length of a string# It would be preferable to use len!!!STRING_LEN = 0While 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 32MY_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 800MY_CLOB=right$(MY_CLOB,800)

Description

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.

Comments

• If EXPR_POS is equal to 0 or 1, the whole string is returned.
• If EXPR_POS is greater than the length of the string, the null string "" is returned.

Associated errors

See also

mid$, left$, seg$, len.