Visual Basic and Visual FoxPro substrings


Left(), Right(), Mid();


Left(), Right(), SubStr(), StrExtract()

Common Syntax Notes

The Left() and Right() functions are the same in both languages. Both take a string and a number as parameters and both will return the leftmost or rightmost n characters of that string. The expression:

Left("Hello Mum", 5)

will return the first five characters of the first parameter passed into the function and will give you the string "Hello".

Note that both languages are 1-based. The first character of the string is character number 1, not zero. In VBA you can use Option Base 0 to force array elements to begin numbering at zero but this option does not affect the way that characters are numbered within a string.

Visual Basic Syntax Notes

VBA uses Mid() to return characters from the middle of the string.

All the VBA string processing functions exist in two forms, one of which has a "$" suffix to indicate that the function will return a string. As an example, the Left() function returns the leftmost characters as a variant data type whereas the Left$() functions returns them as a string.

Visual FoxPro Syntax Notes

VFP uses the SubStr() function to read characters from the middle of a string and also has the StrExtract() function to return the characters between two specified delimiters in a string.

FoxPro has always been a weakly-typed language so there is no need for the distinction between variant (all Fox variables are variant) and string functions. Visual FoxPro does have a set of text-handling functions with a "C" suffix which handle strings in double-byte character sets, for example LeftC().

Concatenation  |  Text functions  |  Trimming spaces