MarcomCentral (PTI) and FusionPro User Communities

MarcomCentral (PTI) and FusionPro User Communities (
-   Formatting Text (
-   -   Table with ampersand in data (

LyndaEngelage February 12th, 2019 10:06 AM

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!

kjacobson February 12th, 2019 11:17 AM

Re: Table with ampersand in data
Hi again!
I answered this on your original thread. Let me know if that solution doesn't work for you.

All times are GMT -7. The time now is 07:00 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
(c) 2011, PTI Marketing Technologies™, Inc.