Search the Community
Showing results for tags 'normalizeentities'.
-
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!
- 1 reply
-
- ampersand
- normalizeentities
-
(and 1 more)
Tagged with: