Special characters to be supported in BI rtf/Etext Template-Replace command

VIDYAJ1274

Organization Name: Securitas Security Services USA

Description (Required): Special Characters in replace command are not recognized by rtf template currently.

Example:  ( ‘ ) and ( ’ ) 

Use Case and Business Need (Required): Vendor system uses ASCII/ISO to process the data. File sent over to Vendor is in UTF-8 and Vendor converts the file from UTF-8 to ASCII/ISO to process in their system. ASCII/ISO does not support certain special characters, hence garbage value is replaced in the place of special character.

Enhancement Request / Service Request: SR 3-29918521401

garbage Char added.png

Actual Char.png

Mark Johnson

Not sure if either of these XSL features would work in RTF templates, but we use characters maps and encoding to remove non-ASCII characters from the Ceridian tax filing extract.

The character maps replace specific non-ASCII characters with equivalent ASCII characters. The encoding removes non-ASCII characters not mapped to ASCII characters.

<xsl:output use-character-maps="BadChr" encoding="US-ASCII" />

<xsl:character-map name="BadChr">

 <xsl:output-character character="À" string="A"/>

 <xsl:output-character character="Á" string="A"/>

 <xsl:output-character character= ...