SUBSTR ​
Returns a portion of a character string.
Reporting Area(s) ​
General
Required Parameters ​
- Field to substring (i.e. loclocat)
--OR-- Character expression to substring (i.e. "Managing Your Time Wisely")
- Character position at which to start substring (i.e. 1, 40)
Optional Parameters ​
- Number of characters to return (i.e. 10)
Example(s) ​
SUBSTR(cocrsenm,1,25) returns the first 25 characters of the course name (i.e. Mastering Student Manager)
SUBSTR(loclocat,41) returns characters 41-through the end of location name (i.e. Konza Room)
SUBSTR(loclocat,41,5) returns characters 41-45 of location name (i.e. Konza)
Notes ​
Standard FoxPro Function