Skip to Content
0
Former Member
Mar 09, 2009 at 03:08 PM

CharacterSeparatedValuesFormatOptions and Problems with a Number field

80 Views

I want to export a report in a comma separated type format using CharacterSeparatedValuesFormatOptions. I set the Delimiter option to "" because I don't want the quotes around the fields. The problem is if the report contains a number field that contains a comma. For example if my data is:

abc 7,459.84 xyz

The data exported looks like:

abc,7,459.84,xyz

Is there a way to eliminate the comma from the number data during the export, otherwise it looks like I have an extra field?