How To Format Numbers As Text So That The Report Output Displays Leading Zeros Without Leading Space?
(Doc ID 2707829.1)
Last updated on SEPTEMBER 06, 2020
Applies to:BI Publisher (formerly XML Publisher) - Version 5.6.3 to 12.2 [Release 5 to 12.2]
Information in this document applies to any platform.
On : 5.6.3 version, Designing Layout Templates
Have custom reports that need to be generated in either PDF or EXCEL format.
In the XML rtf template, in order to preserve the leading ZEROs in the ACCOUNT_NUMBER when generating EXCEL format, define ACCOUNT_NUMBER as 'Regular text' and use Force LTR option.
For example: The xml tag is defined using the below syntax:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?ACCOUNT_NUMBER?></fo:bidi-override>
Although neither the XML rtf template nor the XML output file for the rdf have any spaces, found that when generating selecting EXCEL as an output the ACCOUNT_NUMBER has an invisible leading and trailing space which cause the VLOOKUP function to fail.
The space addition is an EXCEL limitation.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document