CalcBuilder Forum

calculator export csv

Usuario zen11t 2018-03-13 20:10:58

Hi!

I exported my calculator statistics, but when open it with excel and make Text to columns the separator is comma, but my data contains number with comma and dot two.
E.g: number1 = 10,251.01

So excel make column there two.

Can I export my calculator with semicolon separator?


Thanks,
Zen11t

Moonsoft support 2018-03-14 10:01:00

Hi,
yes, you can change both the separator for fields, and also the 'enclosing' char. This can be done at

JOOMLA/administrator/components/com_calcbuilder/views/stats/tmpl/export.php

about line 17 you'll find:

$csv->set_separate_char ( ',' );
$csv->set_enclose_char ( '' );

You can change the separator char replacing the comma for anything else and/or add any enclosing char that would be added for each field.

Hope this helps, regards

Usuario zen11t 2018-04-04 18:57:27

Nice, thank you very much.

Zen11t

...
Support/development

Perfect for small code changes or to correct any bug at your site

Buy now!
...
Support/development 10 hours

Get a bigger amount of hours for more complex tasks and get a 10% discount

Buy now!