Use Microsoft Excel For Your Text Manipulation Needs

I’m just going to lay it out there: sysadmins should use¬†Microsoft Excel more. I probably will be¬†labeled a traitor and a heathen for this post. It’s okay, I have years of practice having blasphemous opinions on various IT religious beliefs. Do I know how to use the UNIX text tools like sed, awk, xargs, find, cut, and so on? Yes. Do I know how to use regular expressions? Yes. Do I know how to use Perl and Python to manipulate text, and do poor-man’s extract-transform-load sorts of things? Absolutely. It’s just that I rarely need such complicated tools in my daily work. I often just have a short list of something that I need to turn into a bunch of …

Read More