The simplest example of an expression is a simple constant, such as:
"Finn and the Fianna" 457.50 '21/2/68' #7000000
There are four different kinds of constants —string, numeric, date and hexadecimal constants. These are shown respectively above. Notice that a string constant must be enclosed in double quotation marks (or inch symbols), a date constant is enclosed in single quotation marks (or foot symbols), and a hexadecimal constant starts with a # symbol. If the string constant were not enclosed in quotes, the expression parser would treat each word as if it were an identifier.
To include a character in a string constant which you could not otherwise include, you need to use an escape sequence. An escape sequence consists of a pair of characters made from the escape character \ (backslash), followed by the escape metacharacter for the character that you want. The metacharacters used by MoneyWorks are " (quote or inch symbol), t, n and \. Their use is shown in the table below:
|quote||\"||"He said \"Fiddlesticks\""|
|newline||\n||"This is line 1\nThis is line 2"|
|return||\r||"The \r of the native"|
|backslash||\\||"The backslash \\ is a special character"|
As an example, to replace all commas in a string with newlines, you would use an expression such as:
Replace(theString, ",", "\n")
As well as the double quotation marks for delimiting strings, you can use the backquote, e.g.
Replace(theString, `,`, "\n")
Having two string delimiters means that you don’t have to use the escape sequence for expressions that involved embedded strings.
Note: Don't confuse the backquote ` with the apostrophe ' — the latter is used to delimit dates.