PerfectForms Forums » Reporting

& and ' appear in data exported via a report

(2 posts)
  • Started 1 month ago by Laura Debello
  • Latest reply from ijobling
  1. Laura Debello
    Member

    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?

    Posted 1 month ago #
  2. ijobling
    Administrator

    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

    Posted 1 month ago #

RSS feed for this topic

Reply

You must log in or register to post.