Strings

Strings

1. String handling functions

   • There are a number of functions that can be used to manipulate a string variable
   • These functions can...
     • identify the length or individual parts of the string
     • convert case or convert between a character and its ASCII value

2. Left String

   • The Left function extracts the left portion of a string

3. Right String

   • The Right function extracts the right portion of a string

4. Mid String

   • The Mid function extracts a substring from the original string

5. The Instr Function

   • The In String
   • looks for a string of characters embedded within the original string
   • returns the starting position of the embedded string

6. Ucase and Lcase

   • convert a string into all uppercase or all lowercase

7. Asc

   • returns the ASCII value of a character

8. Chr

   • returns the corresponding character to an ASCII value