I have a procedure that produces a .csv file to be imported by XL. Been using it for a few years in Pan 6, having trouble now
this line of code:
htmlencode(replace(«Description»,¶,"
")) is producing a different result than before.
[the quoted area above after ¶ should be br with angle brackets on either side, the html code for line break. It’s creating a break rather than showing literally in the posted forum]
«Description» is a text field that may have several paragraphs. It will be encoded into html and uploaded, but since I have to go through XL before I can upload, I don’t want any paragraph returns.
Now, instead of the
[same thing with the break code here] I get,when looking at it in BBedit with Show Invisibles on, an upside down red Question Mark. Tried changing Bbedit preferences to UTF-8. Still have the red question mark.
I’ve tried substituting for ¶ cr() and char(10). Nothing
I’ve tried substitution “X” for “
” [and here] and no “X” shows up.
Tried just htmlencode(«Description») and the paragraphs do not get encoded, though special characters do.
Is there a new way PanX is encoding text, or paragraphs, that I’ve missed?