PerfectForms Forums » Reporting

& and ' appear in data exported via a report

(2 posts)
  • Started 2 years 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 2 years ago #
  2. ijobling
    Member

    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 2 years ago #

RSS feed for this topic

Reply

You must log in or register to post.

Contact

1917 Palomar Oaks Way
Suite 160
Carlsbad, CA 92008
866.900.8588

  picture  picture  picture  picture