Home > SharePoint, SharePoint 2010 > SharePoint 2010: Managed Metadata Converts Ampersand and Double Quotes to Unicode
  1. July 13, 2012 at 22:23

    Nick, thanks for this. It’s helped up track down an issue for a client our. Certain users who have certain browsers are seeing the unicode ampersand as a small box when the term is displayed. So thanks for the cogent analysis for this.

    Are you aware if this is considered by Microsoft to be a bug? I’m certain there was a good reason for doing it in the first place, but it seems to have unintended consequences.

    • July 13, 2012 at 22:28

      Hi Ken

      Glad it helped. I didn’t check with Microsoft on this one since the ampersand was somewhat documented, albeit hard to find!


  2. brendan
    January 23, 2013 at 22:41

    Thank you for your help Nick, this is the exact problem we’ve been having recently. Forgive my ignorance (new to SharePoint) but where do I go/how do I edit the code above or change the TaxonomyItem.NormalizeName so that the ampersand isn’t replaced?

    Thank you!

    • January 23, 2013 at 23:07

      Hi Brendan
      Unfortunately you cannot change this behaviour. You can only work around it by being aware of the problem and updating your code to recognise the converted characters or to convert back when reading them.

  3. gogreen17
    May 13, 2015 at 19:23

    Hi Nick, Thanks a ton for this article. I struggled a lot for finding the fix. Microsoft did a stupid thing converting into a different ampersand.

  4. February 28, 2018 at 16:54

    Hi Nick – How can I get around this ? I have a no – code solution so using your workaround above will not work (or have I missed something)



  5. July 4, 2018 at 16:03

    Apologies Nigel – probably too late now – I didn’t get the notification when you posted your message.

    As a no-code solution, I’m not sure what you are attempting to do. However if you are looking for a CSV extract, then I’d suggest getting the extract, then adding a formula in a new column to transform the data by replacing the 2 characters in Excel, then moving the new values back to the original column to save as the CSV.

  1. September 10, 2012 at 23:19
  2. January 14, 2013 at 15:28
  3. September 13, 2013 at 15:47
  4. March 20, 2014 at 16:01

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: