I have a suitelet that runs N/query for an Advance...
# suitescripts
Suite Deal
03/07/2022, 8:43 PMI have a suitelet that runs N/query for an Advanced PDF report. I'm running into the following error which is related to a text field with an '*&*' (e.g. special character). Any suggestion for handling this encoding issue? I would perefer to tackle this issue pre-PDF, just not sure what the best approach is.
g
Gerald Gillespie
03/07/2022, 8:52 PMxml.escapec
creece
03/07/2022, 9:00 PM?replace('&','&') on the text string in the pdf. No need to do it pre-pdf just add that string for any text strings that can have & in them.
✅ 1
s
Suite Deal
03/07/2022, 9:08 PMThank you! That worked.
g
Gerald Gillespie
03/07/2022, 9:24 PM@creece why not use `xml.escape`(or is it
xml.encodec
creece
03/07/2022, 9:32 PMYou'd have to figure out what you're going to allow in the text string. Its the entity field in this case which is 99% of the time just an & at most. XML escape is a blanket escape and you may not want certain things modified.
creece
03/07/2022, 9:34 PMI'm def down to learn a better way if there is one. Would have to see which version netsuite has of freemarker to see if anything like https://freemarker.apache.org/docs/dgui_misc_autoescaping.html is valid now. You may be able to do a string?xml if its not deprecated in the current version as well which will handle & and a few others.
d
David B
03/08/2022, 9:41 PMlast I checked, NetSuite is using 2.3.26-incubating
📌 I keep the Freemarker version pinned in #C466X49JB
(still 2.3.26 inc. in my 2021.2 SB account)
2 Views