Problem while export report to CSV format

Thanigaivel

Member
- Localization code is BR
- Decimal Separator is ',' ( Comma)
- I have changed the localisation code to BR and Decimal Separator to ','(Comma) for my profile and
we have made the chages in the UBE section of ini

prtCSVExtension=.csv
prtCSVSeparator=,

After changed everything i ran report.
I have attached report in .pdf and .csv both formats.
for example the value 3.244.615,62 in the pdf coming like 3.244.61562 in the .csv file.
The issue is comma is missing.
 
thanigaivel,


Interesting - had you considered that a CSV file is a text, comma delimited file, where commas are used to separate fields/values. Just suppose you put in commas as part of the value, that would screw up your data.

Maybe you should re-think this one ...
blush.gif
grin.gif
 
What release are you on? I thought that this was fixed a looong time ago...

in a csv, if you use comma as a decimal sep and as the field separator, csv supports that this way:
123.456,78 becomes "123.456,78" (quotes around it allow it to keep together). And then also, if you have a string with both commas and quotes, like : Lastname,Firstname "Tog" for someone's name and nickname, in csv it would look like:
"Lastname,Firstname ""Tog"""

Anyway. What release are you on? I haven't actually run this test, but I seem to recall it being and issue that was fixed once...
smile.gif
 
Back
Top