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

contents.gifindex.gifprev1.gifnext1.gif

substitute

Format: substitute( text, substring, rep )

Arguments: (text) text Input text string

(text) substring Target substring to replace

(text) rep Replacement text

Returns: (text) text with all occurrences of substring replaced by rep

Examples: substitute("line of text"," ","-") = line-of-text

substitute("line of text","line","bit") = bit of text

See Also: replace

  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