0

We are receiving these files from the post office that provide address update information. I'm told they are in ASCII format. However, I cant seem to find any sort of delimiter in order to try to convert this into a format I can use for updating our mailing list (which is stored in a mysql database).

I'd like to convert them into a CSV format. But maybe one of you guys can tell by looking at a sample file if theres something obvious that I'm missing.

http://cloud.noahyamen.com/121B2A3v2A1m

Vertexwahn
  • 7,709
  • 6
  • 64
  • 90
Noah Yamen
  • 137
  • 1
  • 4
  • 11
  • 1
    Please post some sample data and whatever code you have tried here. – elixenide Feb 15 '16 at 21:04
  • Read the USPS guide on the [New ACS Format](https://ribbs.usps.gov/acs/newACSformat/ACSFileFormatTechnicalGuide.pdf). It is fixed width... – dawg Feb 15 '16 at 21:05

1 Answers1

0

The header is a 702 character fixed with format with the following fields:

enter image description here

The records are also 702 characters and are described in the ACS document.

You can read more about it at the USPS site for the ACS file format HERE

dawg
  • 98,345
  • 23
  • 131
  • 206