Apex Export to CSV does not remove spaces
I have a classic report that is generated via a SQL statement. The following line formats the total column. I have concatenated ' ' to the formatting so the screen shows a couple of blank spaces before the very long number being displayed. This works fine via the display report screen.
'<b> '|| translate(to_char(NVL(r.LG_amount,0),'999,999,999,999,990.99PR'),'<>','()') || '</b>'
The problem that I am having is when I export to CSV, it is not removing the ' from the result column:
Column result in CSV file shows: " 7,206,387,129.14"
I have the "Strip HTML" set to "Yes". I have tried many options but not having success. I even tried enclosing with "<>" (< >) and this seems to work in CSV eport file but the GUI display screen shows "<> 7,206,387,129.14".
I am using Apex 4.1.0.00.32. Has anyone run into this problem? I appreciate your help on this.