Skip to main content
CalcBuilder logo
CalcBuilder Forum

calculator export csv

User zen11t

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

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

User zen11t

Nice, thank you very much.

Zen11t

...
CalcBuilder

Create dynamic calculators

Buy now!
...
Support/development

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

Buy now!