[jen729w]

Yeah, just yesterday. Hacky output from `nslookup`, not ideal but it’s all we had. Tens of thousands of rows. No IDE with regex capabilities available.

Excel to the rescue! Took me about five minutes to extract exactly what I needed.

[dgacmu]

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

[jen729w]

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.

[jodrellblank]

> "No IDE with regex capabilities available."

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

[jen729w]

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.

[jodrellblank]

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.

[jen729w]

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

[melagonster]

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

[jen729w]

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

[melagonster]

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