My Oracle Support Banner

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.

Goal

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.


Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.