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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Leading zero in zip/postal codes

Received Response
30
Views
1
Comments
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!