Change CSV Delimiter ',' for ';'

[sh4]

Hello!!

The title is descriptive , i'm looking for a workarround to this, in my regional settings, MS Excel by default creates the CSV files using ';' instead of ',' and do not read correctly CSV files using ',' separator. Considering easytable gives an error when i try to read CSV files using ';' separator... Is there any solution easy solution to this, without having to write some php code for converting ';' to ',' before loading the data into easytable?

I'm a bit noob into php programming and it would take me too long, heh.

Thanks!

[support]

Hi sh4,
EasyTable for J! doesn't support different delimiters.

EasyTable Pro for J! will support a variety of delimiters in an upcoming version.

Having said that, you may want to try changing the contoller file:

/administrator/components/com_easytable/controllers/easytable.php

at line 234:

Code: Select all

$handle = fopen($filename, "r");
while (($data = fgetcsv($handle)) !== FALSE)
{


to this:

Code: Select all

$handle = fopen($filename, "r");
while (($data = fgetcsv($handle, 0, ';' )) !== FALSE)
{


Having said that you should be aware of two things:

1. this change hasn't been tested at all
2. once you make this change CSV files with comma's won't import.
3. you do this at your own risk
   
   • if it blows up your computer/webserver/the internet we can't help you

Ok, that was 3 things - hope that helps (and doesn't blow anything up).

[sh4]

Thanks craig for providing this exceptional extension and even support for free.

I will try this

[UncleTaz]

Hi sh4,

You could also leave the code alone, and edit the csv file:

- open it in notepad
- click on edit->replace
- search for ; and replace it with ,

You are done

[sh4]

Hi sh4,

You could also leave the code alone, and edit the csv file:

- open it in notepad
- click on edit->replace
- search for ; and replace it with ,

You are done

Thanks for the advice UncleTaz but craig's code modification worked fine, and now, i have no need to do that in order to import csv's

Thanks.