hey gents,

I'm working on something that will use snmpwalk to query the devices on my network and retreive the device name, device IP, device model and device serial. I'm using Nmap for the enumeration and sed to clean up the results for use by snmpwalk. Once i get all the data organized I'm going to send it to a mysql db. My problem starts once all my sed is done and snmpwalk has done its thing.

Final sed results:
TCF_Distro,10.10.50.2,WS-C3560-24TS,CAT1050RH3D,AHA,10.10.50.3,WS-C3560-24TS,CAT1050RHT2,TCF,10.10.50.4,WS-C3560-48PS,CAT1026RKD3

what I want though is:
TCF_Distro,10.10.50.2,WS-C3560-24TS,CAT1050RH3D
AHA,10.10.50.3,WS-C3560-24TS,CAT1050RHT2
TCF,10.10.50.4,WS-C3560-48PS,CAT1026RKD3

If I can get sed or awk to do this I will not have to do it with mysql commands.

thanks for any assistance.

This is taking place on:
Fedora Core 8 with sed 4.1.5

Try this:

If you get errors use nawk, gawk or /usr/xpg4/bin/awk on Solaris.

Regards

Awesome Franklin52,

Worked like a champ. If you don't mind elaborating on the code so I can understand what is going on.

Thank you.

You can do it directly in sed if you wish:
(use /usr/xpg4/bin/sed on Solairs)

For old versions of sed:

No luck Radoulov,
i received an error that reads

sed: -e expression #1, char 22: unterminated `s' command

char 22 is a } and phpdesigner2008 doesn't see a problem with that.

Without the entire code it would be difficult to debug,
try copy/pasting the code (there is an escaped new line):

With GNU sed you could even write it like this: