Forum
Calc Builder Support
Calc Builder supportForums
No se permite escribir sin estar logado. Por favor, login
calculator export csv 13.03.2018 20:10
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
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
Re: calculator export csv 14.03.2018 10:01
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
Moonsoft Team
www.moonsoft.es
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
Moonsoft Team
www.moonsoft.es