MarcomCentral (PTI) and FusionPro User Communities

MarcomCentral (PTI) and FusionPro User Communities (http://forums.pti.com/index.php)
-   Formatting Text (http://forums.pti.com/forumdisplay.php?f=32)
-   -   Table with ampersand in data (http://forums.pti.com/showthread.php?t=5290)

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;
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!

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.
http://forums.pti.com/showthread.php?p=21709#poststop


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.