Importing PAF file to MySQL

Question

I recently purchased PAF files from the Royal Mail. I've received them all but now need to import the contents into a MySQL database.

After taking a look at the files there seems to be no common delimiter or way to determine the individual columns.

Can anyone please provide any insight into the format of a PAF file so I can build a parser?

Thanks in advance :)

score 0 · Accepted Answer · answered Jan 23 '12 at 10:14

0

I think you should read this PDF file taken from main website: it has everything you need to create a parser IMO.

answered Jan 23 '12 at 10:14

Marco

Thanks Marco, I'd read that previously but couldn't find the information I required. I was hoping there was a delimiter (ie tab-delimited) but turns out each column is X characters long so I've gone with using the field length to split the relevant info out. – BIOSTALL Jan 23 '12 at 11:55
fyi, both those links are broken – Mark Worrall Feb 03 '20 at 10:22
@MarkWorrall: I understand, but this answer is from 2012! And I couldn't have included PDF file in my answer, so the link was the only suitable solution. – Marco Feb 03 '20 at 12:19

1 Answers1