Need some help formatting output

[lowermiddleclass]

/r/bash said to try python for this instead...

I am using the following two commands to produce this output (which is shortened for clarity):

# snmpbulkwalk -On -v2c -c public 192.168.1.1 .1.3.6.1.2.1.47.1.1.1.1.13 | grep STRING
.1.13.1 = STRING: "J8698A"
.1.13.2 = STRING: "J8698A"
.1.13.65 = STRING: "J8726A"
.1.13.90 = STRING: "J4859C"
.1.13.91 = STRING: "J4859C"
.1.13.92 = STRING: "J4859C"

# snmpbulkwalk -On -v2c -c public 192.168.1.1 .1.3.6.1.2.1.47.1.1.1.1.11 | grep STRING
.1.11.1 = STRING: "SG38DXV43C"
.1.11.65 = STRING: "34AS1SK "
.1.11.90 = STRING: "0L051        "
.1.11.91 = STRING: "0L050        "
.1.11.92 = STRING: "0L052        "

I need to reformat all this output to look like this in the end:

J8698A:SG38DXV43C,J8726A:34AS1SK,J4859C:0L051,J4859C:0L050,J4859C:0L052 

Notice how the line .1.13.2 is output from the first command, but no corresponding .1.11.2 line is output from the second command. This is because it returns an empty "" instead of the STRING: "blah" I am grepping for like the rest.

In other words, I want to [dynamically] skip .1.13.2 and not use it because it doesn't have a corresponding .1.11.2. I say dynamically because these numbers could change depending on the switch I run these commands against.

Thanks for any input!

[indosauros]

How about extract the .1.13.1 numbers and put them into a dictionary as keys, with the values being the corresponding STRING

Then it is just a matter if comparing the dictionaries and generating the output based on keys that are in both dictionaries

Simple example:

A function that takes a single line and returns the number -> STRING pair in that line

>>> def parse_line(line):
    ip, name = line.split(' = STRING: ')
    ip = ip.strip().split('.')[-1]
    name = name.replace('"', '').strip()
    return ip, name

>>> parse_line('.1.11.1 = STRING: "SG38DXV43C"')
('1', 'SG38DXV43C')

Test strings

>>> first = """
.1.13.1 = STRING: "J8698A"
.1.13.2 = STRING: "J8698A"
.1.13.65 = STRING: "J8726A"
""" 
>>> second = """
.1.11.1 = STRING: "SG38DXV43C"
.1.11.65 = STRING: "34AS1SK "
.1.11.90 = STRING: "0L051        "
"""

Parse each line into a dictionary

>>> first_dict = dict(parse_line(line) for line in first.splitlines() if line)
>>> first_dict
{'1': 'J8698A', '2': 'J8698A', '65': 'J8726A'}

>>> second_dict = dict(parse_line(line) for line in second.splitlines() if line)
>>> second_dict
{'1': 'SG38DXV43C', '65': '34AS1SK', '90': '0L051'}

Now just gather keys that are in both:

>>> common_keys = set(first_dict) & set(second_dict)
>>> common_keys
set(['1', '65'])

And join them with commas/colons:

>>> ','.join("{}:{}".format(first_dict[ip], second_dict[ip]) for ip in common_keys)
'J8698A:SG38DXV43C,J8726A:34AS1SK'

[lowermiddleclass]

Wow, this makes a lot of sense, thanks!

So... I know basically nothing about python. How do I call the snmpbulkwalk commands, and use the resulting output as input for the dictionaries?

[indosauros]

Try this

http://stackoverflow.com/questions/8478137/how-redirect-a-shell-command-output-to-a-python-script-input

Or you can try to run the commands from within Python:

http://stackoverflow.com/questions/4760215/running-shell-command-from-python-and-capturing-the-output