Use of commas (,) in calculations

[Victor Warner]

I wanted to create a field with a calculation, part of which was to put a number of fields together. For example:

Fields: Town and Postcode

As calculation: Town + ” ” + Postcode

But if I wanted a comma between Town and Postcode the following calculation does not work:

Town + “, ” + Postcode

Nothing appears in the field.

However, if the comma is preceded with a backslash then it does work.

Town + “\, ” + Postcode

I do not believe this is documented in the manual. A normal character (such as a “a” etc) does not, it appears, need the backslash.

If what I describe is correct, what other characters need the backslash? And could this requirement be documented in the manual?

[Brendan]

Hi Victor,

I’ve added a note about this at the end of the Calculations topic in the online user manual.

You need to prefix the comma, semi-colon, and double-quote characters with a backslash character.

[Victor Warner]

Brendan,

Thank you for the information.

[Author]

Posts