Changeset 7575

Timestamp:

2 Feb 2012, 23:03:46 (13 years ago)

Author:

uli

Message:

First silly phone-number converter.

File:

• main/waeup.sirp/trunk/tools/fix_import_file.py (modified) (4 diffs)

main/waeup.sirp/trunk/tools/fix_import_file.py

@@ -31 +31 @@
 import csv
 import datetime
+import re
 import sys
 
@@ -48 +49 @@
     'reg_state': 'reg_state',
     'password': 'password',
+    'phone': 'phone',
     }
 
@@ -82 +84 @@
 ##
 
+# Look for the first sequence of numbers
+RE_PHONE = re.compile('[^\d]*(\d*)[^\d]*')
+
 def convert_fieldnames(fieldnames):
     """Replace input fieldnames by fieldnames of COLNAME_MAPPING.
@@ -175 +180 @@
         if value == "not set":
             return ""
+        return value
+
+    @classmethod
+    def phone(self, value):
+        """ '<num-seq1>-<num-seq2> asd' -> '--<num-seq1><num-seq2>'
+
+        Dashes and slashes are removed before looking for sequences
+        of numbers.
+        """
+        value = value.replace('-', '')
+        value = value.replace('/', '')
+        match = RE_PHONE.match(value)
+        phone = match.groups()[0]
+        value = '--%s' % phone
         return value