Preventing users from entering special characters in the contact details

In certain fields of the contact details, operators can enter any character, including special characters, e.g., a semicolon ";". In terms of contact management, it is not a big issue since operators can remove it manually.

However, when exporting this data, it may become a problem depending on the format, e.g., a semicolon ";" is understood as a column break in CSV files. Operators have thus to manually perform the steps to detect and correct such characters before being able to successfully export the data.

A restriction is done on the back office Contact management to prevent operator entering ";".

This restriction has already been applied on the ticketshop. The set of allowed characters is defined in the INSTITUTION table - column EXTERNAL_ALLOWED_CHARACTERS. Please contact the support team, if you need to add some additional restrictions.

Hereafter the list of fields where the restriction is applied:

First Name, Last Name, Nickname, Passport number
Address Postal code, Town, Address line 1, 2, 3
Contact function, Address Salutation, Letter Salutation