Skip to main content

The PDF generator fails to process records with special characters in mapped fields

An error such as WinAnsi cannot encode "ā" (0x0101) does not mean that mapped text fields are limited to WinAnsi / Windows-1252. The PDF generator now supports extended Latin text.

Supported Characters

Mapped text fields support extended Latin text such as Mārtiņš. Invisible format characters, including zero-width spaces, are removed automatically. The WinAnsi / Windows-1252 list below is a reference, not an exhaustive list of supported characters; support for every Unicode character or script is not guaranteed.

U+0020-U+007E

!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~

U+00A0-U+00FF

¡¢£¤¥¦§¨©ª«¬­®¯°±²³´µ¶·¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖרÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ

U+0152-U+0153

Œ œ

U+0160-U+0161

Š š

U+0178

Ÿ

U+017D-U+017E

Ž ž

U+0192

ƒ

U+02C6

ˆ

U+02DC

˜

U+2013-U+2014

– —

U+2018-U+201A

‘ ’ ‚

U+201C-U+201E

“ ” „

U+2020-U+2022

† ‡ •

U+2026

…

U+2030

‰

U+2039-U+203A

‹ ›

U+20AC

€

U+2122

™

Workaround

You do not need to replace the supported extended Latin characters above or remove zero-width spaces yourself. If another character causes an issue, a targeted substitution formula can be a temporary workaround. The formula below illustrates character substitution; it is not required for the characters shown:

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({TITLE},"ā","a"),"Ā","A"),"​","")

This would substitute ā with a, Ā with A, and remove the zero width space character (that character may be stripped from this article, so you may need to insert it again between the second-to-last set of quotation marks if you're copying this example formula), in a field called TITLE.

If you need a substitution workaround for a different problematic character, use the resulting formula field in the field mappings for the PDF generator instead of the original text field. ChatGPT can help you generate a formula for the specific character(s) you need to replace.

Did this answer your question?