The Find/Correct Illegal Data Utility is very easy to run and will generate a complete report of illegal characters in your database. These illegal characters (such as double quotes and parentheses) can cause rosters, mail merges, and other programs to behave erratically. Using this utility, you can easily print a report of all illegal characters and even have the system remove the characters from the database for you.

In addition, this utility will alert you to any email addresses with bad formatting, such as those missing the "@" symbol or the three-letter “.com” extension.

NOTE: The utility will not correct bad email addresses but the report enables you to quickly find records that need to be corrected.

To run the Find/Correct Illegal Data Utility

Navigate to System Setup > Utilities > Find/Correct Illegal Data to open the utility.


It's a good idea to run the "Report Only" option first so that you can review any changes that will be made. Once you have the report, you can choose to manually correct illegal characters or select the "Correct and Report" option to let Cloud AMS do the work for you.