1 files changed, 26 insertions, 0 deletions
diff --git a/library/Director/PropertyModifier/PropertyModifierXlsNumericIp.php b/library/Director/PropertyModifier/PropertyModifierXlsNumericIp.php
new file mode 100644
index 0000000..969068e
--- /dev/null
+++ b/library/Director/PropertyModifier/PropertyModifierXlsNumericIp.php
@@ -0,0 +1,26 @@
+<?php
+
+namespace Icinga\Module\Director\PropertyModifier;
+
+use Icinga\Module\Director\Hook\PropertyModifierHook;
+
+class PropertyModifierXlsNumericIp extends PropertyModifierHook
+{
+    public function getName()
+    {
+        return 'Fix IP formatted as a number in MS Excel';
+    }
+
+    public function transform($value)
+    {
+        if (ctype_digit($value) && strlen($value) > 9 && strlen($value) <= 12) {
+            return preg_replace(
+                '/^(\d{1,3})(\d{3})(\d{3})(\d{3})/',
+                '\1.\2.\3.\4',
+                $value
+            );
+        } else {
+            return $value;
+        }
+    }
+}