I'm constructing a table of seventeen columns of three characters each on raffle tickets. The data in the csv file has each group of three characters horizontally in a cell. The following code takes each cell and turns it into a vertical column of three characters:
Position1 = Left(Field("Wk01"), 1);
Position2 = Mid(Field("Wk01"), 2, 1);
Position3 = Right(Field("Wk01"), 1);
return Position1 + '<br>' + Position2 + '<br>' + Position3 + '<br>';
The returned string is interpreted as tagged text. I suspect that, whenever the character is an ampersand, FP assumes it's the first character in an entity, and returns the error (as well as, apparently, placing the ampersand character correctly in the column).
In order to get rid of the "incomplete entity definition" errors, I was trying to modify the rule to test whether a particular character was an "&", and to substitute "&" for the "&", but I keep getting syntax errors, so either it's not the solution, or I'm having pilot error writing javascript.
Any hints on how to make this work (or, almost as good, confirmation that I'm getting the correct result from FP, despite the errors, and can ignore them)?
Thanks,
Steve