IBM Accelerator Catalog
IBM Accelerator Catalog

How to handle leading zeros in zip codes in uploaded files

Some zip codes in the United States contain leading zeros (e.g. 06533). Text file formats such as Excel or CSV remove leading zeros from numbers. If your data contains invalid zip codes (e.g. 6533), how can we add the leading zero back in?

Slide Two

About this accelerator

Some zip codes in the United States contain leading zeros (e.g. 06533). Text file formats such as Excel or CSV remove leading zeros from numbers. If your data contains invalid zip codes (e.g. 6533), how can we add the leading zero back in?

Additional details

  • Accelerator typeHow to
  • IndustryAny
  • Business functionAny
  • Product and version Cognos Analytics - 11.1.7 to Current
  • Author typeIBM
  • Company nameIBM
  • Author name IBM
  • Last modifiedMay 19th, 2021
  • Language English