1 Reply Latest reply on Nov 15, 2011 6:22 PM by disabled_winfried

    On Importing Spaces are Replaced with Commas


      Hi There

      Im trying to import a phone number 0412 666 999 (0412 (SPACE) 666 (Space) 999)

      When I import into one db the number imported is correct 0412 666 999

      When I import into the other db the number imported is 0412,666,999 (0412 (COMMA) 666 (COMMA) 999

      (Fields in db are NUMBERS)

      This is what Ive Done:


      Turned off Smart Quotes

      Recovered the incomming db

      Re entered the phone number

      Placed the field Phone Number as a related field, the number is displayed correctly

      Imported into another db and the number imports correctly

      Indexing is set to ENGLISH

      System settings is set to Use System Settings


      When I change the Field to TEXT (from number) , the number imports correctly


      Somebody got any ideas