Page 1 of 1

not using the , in a csv file

PostPosted: Sat Apr 04, 2009 1:27 am
by PolderBoy
Hello All,

I am importing a csv file which has a ; as a dilimiter

I need to change the Xataface code so that the ; is used instead of ,

Where I live the comma is used in a currency (0,00) So that is a problem when importing a currency.

Can I change this somewhere?

Thanks in advance.

PolderBoy

PostPosted: Sun Apr 12, 2009 10:30 am
by shannah
Since you need to write your own import filter to import records, you have programmatic control over how you import the records. The fgetcsv function allows you to specify the delimiter as the third parameter. Just set this to ';'.

http://ca.php.net/manual/en/function.fgetcsv.php

-Steve