AnsweredAssumed Answered

Bold text element fails if there is a & symbol

Question asked by deleted-user-MS0lE1F_0-sy on Aug 5, 2015
Latest reply on Aug 5, 2015 by iamurray

So I have a massive amount of data I need to get into a text element, so I wrote a python script for this.


textValue += "<BOL>" + row[0] + ": </BOL>" +  row[1]  + " - " + row[2] + '\r\n'


It works great.


     001: John Doe - 12345

     002: Jane Smith - 67890


The problem happens when a "&" symbol is introduced.


     <BOL>001:</BOL> John Doe - 12345

     <BOL>002:</BOL> Jeff & Jane Smith - 67890


I get that this is a formatting rule issue, but is there away I can get around this.   I guess I could write a script to replace all “&” with “and” but I prefer not to.  I appreciate any suggestions.