Unwanted collapsing of double spaces
I have data in some CRMOD fields that contains double spaces. It isn't pretty but it needs to be that way in order to exactly replicate values from another data source.
The field value preserves the double spaces and I can see this only when the field is open for editing.
I have these 2 issues:
a) The UI collapses the 2 spaces into 1 when displaying the values.
b) The reports containing the data collapse the 2 spaces.
This is really a pain. How can I instruct the report to produce the actual field value instead of what it thinks the value should be? How can I instruct the UI to display the actual field value?