- Business users occasionally needs to manipulate large data set that usually comes in the from of text files like CSV or TSV, and hit the limit of the spreadsheet tools like Excel.
- Probably two of the most common issues are (1) slightly broken CSV file, and (2) a really large file that can freeze Excel upon opening.
- Most people think they needs programming languages like Python, but usually the result can be achieve using simpler too like text editor or command line interface (like Sublime Text that I'll be introducing here). In addition, for people who aren't really used to programming languages, memorizing syntax and executing them without errors can be quite challenging.
- Sublime Text is the tool that I'll use to introduce this concept. It's free to evaluate and available cross-platform
- Download and install at https://www.sublimetext.com/download
- It's basically a more powerful Notepad, there's a lot of helpful tool but remain lightweight
Naphat Korwanich naphat-k
naphat-k
/ sublime-csv-handling.md
Last active
April 29, 2022 15:30
Advanced CSV file handing using Sublime Text