Junk Characters in XML Publisher Excel Output
When converting number to Text and viewing output in Excel there are additional junk charecters '?' coming in excel. I uploaded some files, in section:" BI Publisher All Community Documents "
Created a template using Bi Publisher. Uploaded the XML data. For all the fields where the data is having 'o' in the start added the syntax <fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> to preserve the leading 0. View the output in Excel. The output has additional junk characters '?' on both side of data.
Why is this happening?
Thanks a lot for any hint.
Created a template using Bi Publisher. Uploaded the XML data. For all the fields where the data is having 'o' in the start added the syntax <fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> to preserve the leading 0. View the output in Excel. The output has additional junk characters '?' on both side of data.
Why is this happening?
Thanks a lot for any hint.
1