Skip to Main Content

Qualitative Research: Cleaning Text

Cleaning Text

Often you will need to reformat or clean the text you collect, for easier use in analytical tools.

Cleaning/Parsing guide from A. Zoss

See Introduction to Text Analysis, Cleaning/Parsing tab for:

File conversion
Manually structuring with Word and Excel; help with regular expressions
Correcting/standardizing text

Re-formatting instructions

Nexis Uni results to Excel
how to reformat Nexis Uni results for use in Excel
Nexis Uni results to JMP
How to reformat Nexis Uni results for use in JMP; useful for generating a random sample of results
ProQuest Newspapers to Excel and JMP
how to reformat ProQuest Historical Newspapers results for use in Excel and JMP; useful for generating a random sample of your results

The textual data you gather often needs to be re-formatted for use in analysis software.