When your work involves typing and manipulating data files with many different sources then you wind up with different tasks that can be accomplished in many ways. What are your favorite text editors or ways of manipulating text for different tasks?
This is the newest editor in my toolbox. It has really good support for markdown and you can use it to open a regular file folder and access all of the contents. Lots of plugins and themes available.
I've used this for years and gotten a lot of enjoyment out of it. The code highlighting is entirely customizable in addition to the themes that are available online. There are plugins, but I've personally had issues with using them on my work laptop due to user policies. One great feature is that when you close Notepad++ it will actually keep any unsaved work that you have without having to save the file anywhere explicitly. I used this for years to keep text files for completing tasks where the information wasn't relevant long term. VSCode is actually starting to replace this for me, especially with my decision to start using markdown to keep notes together that might include several different languages.
While being really similar to Notepad++, Programmer's Notepad has a find/replace functionality that can use mixed backslash characters (\n, \r, \t, etc.) and simple regular expressions. While the finding could be done with regular expression in another editor, Programmer's notepad will let you replace the new line characters easily, which I found to be usefule when dealing with reformatting of data extracts and programmatically formed queries.
Anytime that I need to run Python code, or run Java projects (including Maven, Gradle, and Springboot tasks) then I greatly prefer the JetBrains editors. Also, the tooling for interaction with version control systems is top shelf! The merge tool, diff, and local history are very helpful. I also find that the global find tools are better than the rest. There are separate tools for finding a file name that contains your string or finding the string in a file. The global string replace tool has assisted me with package restructuring of java projects without effort.
Writing queries with code completion with your actual database information is great. It helps that you can execute queries and export result data in multiple file formats.
While it seems a bit out of place in a discussion of code editors, when you have comma separated data that needs to be reformatted adhoc then Excel can be a really good tool, especially when coupled with another pure text editor. We had a playbook that clients would fill out that I would have to translate into insert statements for the database (it actually controlled the functionality of our application), and I would use Excel to move the columns around, clear out unnecessary data, and then I could paste the first and last parts of the insert statement into the first and last columns of the spreadsheet.
This is the only tool that I've found that will quickly and easily make everythin lowercase. That's really all that I use it for. Well, that and having to occasionally write documentation that will be for someone who isn't a programmer.
Grep helps you to pull out the data that does/doesn't match a given pattern/string.
Sed helps you to replace a given pattern/string (even several at a time).
Awk is really helpful for pulling out certain pieces of column formatted data.
It's also important to note that with these tools that you really get the most power out of them when you start chaining them together with linux command line pipes ("|") and output redirects (">" or ">>") to write files or
wc -l to count the lines.
Altogether these things can be used almost like sql from the linux command line.
Python is really quick and powerful for writing text manipulation scripts. Opening a file, iterating through it's lines, splitting the line into variables and checking for given values can be achieved in 5 lines of code.
with open('file.csv', 'r') as input_data: for line in input_data: a, b, c, d = line.split(',') if b = 'fubar': do(thing)