AnsweredAssumed Answered

Bold text element fails if there is a & symbol

Question asked by mbd7878 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.

Outcomes