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

...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!
...
Support/development 10 hours

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

Buy now!