| Applying science to business management |
   
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.
|
