You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Leading zero in zip/postal codes

    edited Oct 3, 2018 4:59AM in Reporting and Analytics for HCM 1 comment

    Summary

    Can we protect postcodes when converting to csv?

    Content

    I'm running a report containing global postal address data and any countries with zip / postal codes with a leading 0, the 0 is dropping off when converting to csv.  I've tried converting to a txt file instead and using the Excel Data Import tool, but I don't want to edit the whole column, just those affected.  Is there a way to designate the post / zip code field as text so the leading 0 doesn't drop off on conversion?  Thanks

    Version

    Oracle Business Intelligence 11.1.1.9.0
    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!