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

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.

  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