Prior version 3.08, Crossware Mail Signature did not support the use of double quotes in a formula look-up.

eg. @UpperCase("(!LastName!)")

This would result in: (!formula text="@UpperCase("(!LastName!)"))

The parser would return the following formula that would then fail to compile:

@UpperCase(

This fix is required when the need to double quotes is required in the formula.

This would cause problems:

e.g. when the data returned from a lookup containing a single quote:

lookup (!LastName!) returns the data "O'Mally"

this is then used in another lookup e.g. (!UpperLastName!)

@UpperCase('(!LastName!)')

would evaluate to:

(!formula text="@UpperCase('(!LastName!)'))

(!formula text="@UpperCase('O'Mally'))

This would cause the formula to fail to compile.

With this fix, the above formula can then be converted to the following:

@UpperCase(\"(!LastName!)\")

The parser will recognise the escaped quotes and not use them in determining the "text" parameter of the formula.

This fix was implemented in Version 3.08