Need help with Parsing Date in Universal Device Poller

I'm working on some SNMP pollers for tripplite ups systems. I'm trying to build a table of the Battery Replacement and Battery Test dates. They show up in the following format: 20100231 . I would like it to say instead 2010-02-31 or preferably 02-31-2010. I'm pretty terrible with regular expression, but I attempted to make a transform with the following formula:

parse((/([0-9]{4})([0-9]{2})([0-9]{2})/\2-\3-\1/), {TLUPSConfigBattReplDate})

Could someone look at it and give me a hand with writing it?

Find more posts tagged with

network_monitoring

transform_pollers

universal_device_poller

network_management

Accepted answers

All comments

JiriPsota

I am afraid this is not possible. The result of the transform poller has to be a number. Parse function is here to be able to parse numbers from strings.

damienball

Oh ok. That's poopy. Is there a way to present this particular OID in a more readable fashion without using transform pollers?

knewbry

What's the OID #?

JiriPsota

Where would you like to see the value? You can use SQL to format the value. SQL can be used in old Report Writer, new web based reporting or custom table resource.