qb45advr.hlp (Topic list)
Important Notice
The pages on this site contain documentation for very old MS-DOS software, purely for historical purposes. If you're looking for up-to-date documentation, particularly for programming, you should not rely on the information found here, as it will be woefully out of date.
String Manipulation Statements and Functions
  Programming Tasks   String Manipulation   Contents   Index
──────────────────────────────────────────────────────────────────────────────
Statements and Functions Used for String Manipulation
 
                        Statement or
Task                    Function                        Action
 
Getting part of         LEFT$              Returns a given number of
a string                                   characters from the left side
                                           of a string
 
                        RIGHT$             Returns a given number of
                                           characters from the right side
                                           of a string
 
                        LTRIM$             Returns a copy of a string with
                                           leading blank spaces stripped
                                           away
 
                        RTRIM$             Returns a copy of a string with
                                           trailing blank spaces stripped
                                           away
 
                        MID$(function)     Returns a given number of
                                           characters from anywhere in a
                                           string
 
Searching strings       INSTR              Searches for a string within
                                           another string
 
Converting to           LCASE$             Returns a copy of a string with
uppercase or                               all uppercase letters (A-Z)
lowercase                                  converted to lower-case letters
letters                                    (a-z); leaves lowercase letters
                                           and other characters unchanged
 
                        UCASE$             Returns a copy of a string with
                                           all lowercase letters (a-z)
                                           converted to upper-case letters
                                           (A-Z); leaves uppercase letters
                                           and other characters unchanged
 
Changing strings        MID$(statement)    Replaces part of a string with
                                           another string
 
                        LSET               Left justifies a string within
                                           a fixed-length string
 
                        RSET               Right justifies a string within
                                           a fixed-length string
 
Converting numbers to   STR$               Returns the string representation
strings, and strings                       of the value of a numeric
to numbers                                 expression
 
                        VAL                Returns the numeric value of a
                                           string expression
 
Converting numbers      CVtype             Changes numbers stored as strings
to data-file strings                       back to Microsoft Binary format
and data-file strings                      numbers in programs working with
to numbers                                 random-access files created with
                                           older versions of BASIC
 
                        CVtypeMBF          Changes numbers stored as
                                           Microsoft Binary format strings
                                           to IEEE-format numbers
 
                        MKtype$            Changes Microsoft Binary format
                                           numbers to strings suitable for
                                           storing in random-access files
                                           created with older versions of
                                           BASIC
 
                        MKtypeMBF$         Changes IEEE-format numbers to
                                           Microsoft Binary format strings
 
Creating strings of     SPACE$             Returns a string of blank
repeating characters                       characters
 
                        STRING$            Returns a string consisting of
                                           one repeated character
 
Getting the length      LEN                Tells how many characters are
of a string                                in a string
 
Working with            ASC                Returns the ASCII value of the
ASCII values                               given character
 
                        CHR$               Returns the character with the
                                           given ASCII value