Strings

In my experience these functions are used more than just about any of the other VB built-in functions. The FORMAT, MID, and INSTR functions are incredibly powerful and I use them extensively. If you don't understand what they are, they are worth the time to figure out! The LEN and CHR functions are also valuable as are the variations on the trim and case functions.

• Left - Returns the left n characters of a string
  
  
  
  • temp$ = right$ ( teststring$, 4 )
  
  
• Trim - Removes leading and trailing spaces of a string
  
  
  
  • temp$ = ltrim$ ( teststring$ )
  
  
•  RTrim - Removes only the trailing spaces of a string
  
  
  
  • temp$ = ucase$ ( teststring$ )
  
  
•  LCase - Makes all characters lower case
  
  
  
  • temp$ = mid$ ( teststring$, 1, 4 )
  
  
• Len - Returns the length of a string (how many characters it has)
  
  
  
  • temp$ = lset ( teststring$ )
  
  
•  RSet - Positions a string inside another, flush to the right
  
  
  
  • temp$ = format$ ( teststring$, "####.0" )
  
  
• String -
  
  
  
  • temp$ = str$ ( 32 )
  
  
•  Asc - Returns the ASCII code of a single character
  
  
  
  • temp$ = space$ ( 15 )
  
  
•  Instr - Determines if one string is found within a second string
  
  
  
  •  i  = InStrRev (string1, string2, start)
  
  
•  StrComp - Compares two strings
  
  
  
  • 
    
    
    
    •  StrReverse  (string1)
    
    
  • Replace - Replaces each occurrence of a string
    
    
    
    •  FormatCurrency (var1, 2)
    
    
  •  FormatDateTime - Returns a date or time expression
    
    
    
    •  FormatNumber (var1, 2)
    
    
  •  FormatPerCent - Returns a number formated as a percent
    
    
    
    • Arrays
      
      
      

      Every programmer  uses arrays. You can resize an array with REDIM without losing the data.

      
      
      
      
      • Option Base - Determines whether the lowest range of an array is 0 or 1
        
        
        
        • option base 1
        
        
      • Erase - Erases all values of an array
        
        
        
        • erase ( arrayname)
        
        
      • Dim - Creates an array
        
        
        
        • dim arrayname(25)
        
        
      •  Redim - Resets the bounds of an array (has option to save values)
        
        
        
        •  redim  arrayname(28)
        
        
      •  UBound - Returns the upper dimension of an array
        
        
        
        •  i  = ubound (arrayname)
        
        
      •  LBound - Returns the lower dimension of an array
        
        
        
        •  i  = lbound (arrayname)
        
        
      • Filter - Returns a subset of an array based on a filter
        
        
        
        • Filter (inputarray, searchstring)
        
        
      • Array - Yes, there is a function called array. It returns an array that has been filled with data from a list. It allows you to put the actual data values in the code to avoid having the user input it or to avoid having to read it from a file
        
        
        
        •  ArrayName  = Array (10, 20, 30)
        
        
      • Join - Concatenates strings within an array