If you can use dig output, the next time you need to do something like this you might find 'jc' helpful: https://github.com/kellyjonbrazil/jc

Government laptop. No can use anything that isn’t whitelisted.

This is the beauty of Excel. It’s a powerful text manipulation tool that everyone has.

> "No IDE with regex capabilities available."

If it's Windows there should be PowerShell ISE installed.

I know I should learn it but, I dunno, I just really dislike the PowerShell syntax. I get what they were going for with the Verb-Noun thing but it just reminds me of AppleScript and I can’t stand it.

You don't have to learn or use PowerShell to paste something into the ISE editor and go to 'Edit -> Replace in Script' and do a regex search/replace.

Ahaaa cool tip, that will be useful one day. Thank you.

where can I input regex to excel? I really need that, last time I copied table to nopad++ then copy paste it back.

I didn’t. I pasted the output and munged it with Excel’s trusty text functions.

so in this time, Excel isn't so good...