View Single Post
Old February 12th, 2019, 10:06 AM
LyndaEngelage LyndaEngelage is offline
Junior Community Member
Join Date: Sep 2014
Posts: 39
Default Table with ampersand in data

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;

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!
Reply With Quote