We have a specific format for our SNMP location fields in our devices so that we can get more than just the traditional location. The fields are separated by a pipe (|) symbol, and a previous monitoring tool was able to read and parse out this info into different fields.
For example:
123 Main St, New York, New York, 10001|FLOOR:11C|ROOM:MDF|ASILE:2|BAY:A1
I'd love to be able to pull out the different fields automatically into custom fields that I can use for grouping and sorting. Any suggestions?