4 ms·
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 t
by jen729w 4y ago
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 4y agoIf 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 https://github.com/kellyjonbrazil/jc
- jen729w 4y agoGovernment 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.
- melagonster 4y agowhere can I input regex to excel? I really need that, last time I copied table to nopad++ then copy paste it back.
- jen729w 4y agoI didn’t. I pasted the output and munged it with Excel’s trusty text functions.
- melagonster 4y agoso in this time, Excel isn't so good...
- jodrellblank 4y ago> "No IDE with regex capabilities available." If it's Windows there should be PowerShell ISE installed.
- jen729w 4y agoI 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 4y agoYou 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 4y agoAhaaa cool tip, that will be useful one day. Thank you.