Vanguard Software
Forecasting & Planning Solutions
Home Products Solutions Services Customers Partners Company
 
Applying science to business management

contents.gifindex.gifprev1.gifnext1.gif

substring

Format: substring( text, offset, len )

Arguments: (text) text Input text string

(int) offset Starting location of the substring

(int) len Length of the substring

Returns: (text) The portion of text beginning at offset and containing len characters

Examples: substring("A text string",0,3) = A t

substring("A text string",2,7) = text st

substring("A text string",2,100) = text string

substring("A text string",100,7) = (null text string "")

See Also: find

  Demand Planning  |  Financial Forecasting
Forecasting Software  |  Strategic Planning Software  |  Decision Tree Software
Decision Support Software  |  Expert System Software  |  Online Surveys

Contact Us  |  Terms of Use  |  Privacy Policy  |  Site Map
Vanguard Software
© 2011 Vanguard Software Corporation
Print this page   Email this page to a friend