TACTIC - Text Cleaning & Autocorrect

Developed by Ipsos ACE

Text Cleaning & Autocorrect attempts to correct all spelling and grammar errors within each text. There is also the optional capability to replace expletives with less profane vocabulary.

1. Upload a CSV, XLSX, or SAV file containing a column of text using the "Choose File" button.
   1. If you uploaded a multi-sheet XLSX file, you will be given the option to select the sheet name which holds the text data.
   2. You will be given the option to select the column name for the text column.
   3. Check the "Remove PII" checkbox to have TACTIC remove personal identifiable information (PII). Always check every row to verify that PII removal succeeded for each text.
   4. Check the "Remove code" checkbox to have TACTIC remove code, tags, and other markup language.
   5. Check the "Remove texts with no alphanumeric characters" checkbox to have TACTIC remove texts that contain only non-alphanumeric characters (i.e. punctuation only).
   6. Check the "Remove texts with no letters" checkbox to have TACTIC remove texts that contain no letters (i.e. only numbers and punctuation).
   7. Check the "Remove expletives" checkbox to have TACTIC replace profanities with less offensive wording.
   8. Check the "Remove hyperlinks" checkbox to have TACTIC remove web addresses.
   9. Check the "Remove hashtags" checkbox to have TACTIC remove hashtag and @mentions.
   10. Hit the "Upload Text Data" button.
2. After uploading the file, you can view the data in the DATA tab at the bottom of the screen.
3. Before hitting the RUN button, evaluate the estimated cost and number of texts. Hit RUN.
4. After a few moments, general statistics on the process will be displayed in the CORRECTIONS tab at the bottom. To view results for each row, refer to the DATA tab.
5. If you are pleased with the results, you can download a XLSX of the results using the "Export Report" button in the "Data Control" section.

TACTIC Walkthrough Video

User Feedback & Bug Report Form