Vanguard Software
Forecasting & Planning Solutions

contents.gifindex.gifprev1.gifnext1.gif

Text Operators

There are only two operators designed specifically for use with text strings. Each is described below.

Quote "x", 'x'

Double- and single-quote marks are used to create text string literals. For example,

"My text string"

Add x+y

The Add operator is used both for numeric addition and for text concatenation. When Add is used to concatenate text strings, it simply appends the string y to the string x and returns the result. For example, the expression "My "+"text" is the same as "My text".

If either of the operands used with the Add operator is a text string, the operator performs text concatenation instead of numeric addition. If one of the operands is a text string and the other is a number, the number is converted to a text string. When entering expressions that rely on this automatic conversion, it is important to consider the order in which multiple Add operations are performed. For example, the expression "A="+2+3 will produce the result A=23 not A=5. The reason for this is that the Add operations are performed in the same order as the following expression ("A="+2)+3. In contrast, the expression "A="+(2+3) will produce the result A=5.

  Forecasting Software  |  Strategic Planning Software  |  Decision Support Software
Decision Tree Analysis  |  Monte Carlo Simulation Software  |  Risk Analysis Software
Portfolio Analysis Software  |  Expert System Software  |  Customer Questionnaires

Contact Us  |  Terms of Use  |  Privacy Policy  |  Site Map
Vanguard Software
© 2010 Vanguard Software Corporation
Home Products Solutions Services Customers Partners Company
Vanguard
Applying science to business management
Vanguard
Print this page   Email this page to a friend