When I try to scrub a list, I get a "Syntax Error"

Top  Previous  Next


We see this error most often when users attempt to scrub an Excel spreadsheet. Because Excel will allow any character to appear in the "column header" record of the list, it is possible for the creator of the list to include characters that Call List Scrubber cannot process. Call List Scrubber is designed to remove any invalid characters prior to trying to use the column headers as field names. Unfortunately, sometimes this produces duplicate field names and when it does Call List Scrubber cannot continue. It might also be that after removing the invalid characters, the remaining characters still produce and invalid field name.

There are two ways to work around this problem:

1.Go back to the original call list and edit the column headers to be short (under 10 characters) and/or eliminate any invalid characters (such as * ,, &, ^, #, @, etc.). Then try to scrub the list again.
2.Re-scrub the list, and this time remove the check mark from the 'Field Names are in Row 1' box as shown in the two screens below. When you do this, Call List Scrubber will automatically assign field names such as FIELD1, FIELD2, etc. You can still check the sample box to see what a particular field contains and the process should continue normally after that.