Jump to content

Table with ampersand in data


LyndaEngelage

Recommended Posts

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!

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...