2.1.1126 Part 4 Section 3.18.96, ST_Xstring (Escaped String)

a.   The standard implies that the only characters that can be Xstring encoded are invalid XML characters.

The following four cases represent valid XML characters that should be escaped:

Carriage Return (0x000D): This character shall be escaped.

Line Feed (0x000A): This character shall be escaped only when used in an attribute.

Tab (0x0009): This character shall be escaped only when used in an attribute.

Underscore (0x005f): This character shall be escaped only when used to escape the first underscore character in the format _xHHHH_.

b.   The standard allows Xstring to encode underscores using _x005f_.

In Excel, Xstrings may only contain the escape sequence _x005f_ when escaping the lead underscore from a string in the form _xHHHH_.

Show: