Does anyone know of a tool that will reformat a cut+paste of a bgp forwarding table correctly. Maybe an excel sheet with formula embedded or something similar that will create a single line per subnet route.
I'm trying to compare 3 VRF routing tables to find duplicates. The largest is 80,000 lines.
Due to the CLI column widths on the output of 'sh ip bgp' the longer subnets cause a line break in the output. This means when I come to cut and paste into excel and then try and use the 'Text to columns' tool it does not work correctly. If I copy to Word or notepad first I have hundreds of lines to manually edit.
Surely other people out there have hit this frustrating problem ? Previously I've just bitten the bullet and fixed the formatting manually but these large routing tables will take too long to fix and possible introduce errors in the process.
Any advice ?
Thanks
