LyndaEngelage Posted February 12, 2019 Share Posted February 12, 2019 I'm working on a Table that works great except data that has the ampersand (&) returns unexpected results. Example B&A Scholarship Fund returns B Scholarship Fund The "&" is getting stripped including anything until the next word. I know I have to use the NormalizeEntities function but in this particular case don't know where or how to write the syntax. Here's the table: new FPTable; var table = new FPTable; table.AddColumns(13500,1800,5400); for (i=1;i<=12;i++) {//Loop through fields if (Field("Amount_"+i)!="") {//add a row if the Amount field is not empty var tableRow = table.AddRow(); tableRow.Cells[0].HAlign = "Left"; tableRow.Cells[1].HAlign = "Center"; tableRow.SetContents(Field("Designation_"+i),Field("GC"+i),Field("Amount_"+i)); //Add content to the columns for (c=0;c<=2;c++) {//loop through cells to apply margins & font tableRow.Cells[c].Margins = { Top:0, Bottom:68, Left:0, Right:0 }; tableRow.Cells[c].Font = "Crimson Roman"; } } } var totalRow = table.AddRow(); //Add total row totalRow.Cells[0].HAlign = "Left"; totalRow.Cells[2].HAlign = "Center"; totalRow.SetContents("TOTAL 2018 TAX-DEDUCTIBLE GIVING:","",Field("CAL18_TTL")+"*"); //Set total row content for (c=0;c<=2;c++) {//loop through cells to apply margins & font totalRow.Cells[c].Margins = { Top:0, Bottom:68, Left:0, Right:0 }; totalRow.Cells[c].Font = "Brandon Grotesque Bold"; } return table.MakeTags(); Any help would be greatly appreciated! Quote Link to comment Share on other sites More sharing options...
kjacobson Posted February 12, 2019 Share Posted February 12, 2019 Hi again! I answered this on your original thread. Let me know if that solution doesn't work for you. http://forums.pti.com/showthread.php?p=21709#poststop Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.