Home › Forum › Reporting › & and ' appear in data exported via a report
Tagged: Exporting Data
This topic contains 1 reply, has 0 voices, and was last updated by Laura Debello 8 years, 10 months ago.
When I export data froma report data list, and the value in a field has an “&” instead of the word “and” and/or an apostrophe, the value exported shows up with “&” or “'” respectively.
For example: the field Book Title contains “The Lion, the Witch & the Wardrobe”. When this is exported it shows up as “The Lion, the Witch & the Wardrobe”.
Another example: the field Last Name contains “O’Malley”, but it is exported as “O'’Malley”.
Why is this happening?
its all down to how we store the data that causes this in some environments but it is something we are looking at to improve (ie ensure things like the ‘ aren’t presented as ') in a future update
You must be logged in to reply to this topic.