Browse more 5,000 tipsheets from our national conferences and Watchdog Workshops on how to cover specific beats, conduct a great interview and learn countless tips on where to find the information you need.
Search results for "text editors" ...
Regular expressions are a powerful tool when working with data, especially when dealing with values that are formatted inconsistently. They're supported by a variety of text editors, databases and programming languages, but they can be pretty daunting if you've never dealt with them before. Learn about the basics of regular expressions and how they can help with your next batch of dirty data.
This tipsheet goes through pros and cons of 32 different free tools of different functions ranging from spreadsheets, text editors and database managers to data visualization tools and FOIA request trackers.
This handout covers some commands that would significantly improve the process of cleaning data using the program UltraEdit. It includes a "quick hit" list of symbols and the functions to which they correspond.