& and ' appear in data exported via a report

Home Forum Reporting & and ' appear in data exported via a report

This topic contains 1 reply, has 0 voices, and was last updated by  Laura Debello 8 years, 10 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #390

    Laura Debello
    Participant

    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&#39’Malley”.

    Why is this happening?

    #5003

    ijobling
    Participant

    Laura

    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 &#39) in a future update

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.