Text Operators
Following are operators designed specifically for use with text strings:
| Operator | Description |
|---|---|
| Quote | "x", 'x' Used to create text string literals. For example: "My text string" |
| Add | x+y 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, consider the order in which multiple Add operations are performed. For example, the expression "A="+2+3 produces the result A=23 not A=5. The reason for this is that Add operations are performed in the same order as the following expression: ("A="+2)+3 In contrast, the expression "A="+(2+3) produces the result A=5. |