3ltr code from us gov -> help building an huge list

Having a problem with the routes site, or want to report a missing airline or airport? This is the place for you.
loww
Posts: 86
Joined: Sun Jun 28, 2015 10:55 am
Location: LOWW
Contact:

3ltr code from us gov -> help building an huge list

Postby loww » Sun Nov 08, 2015 5:16 pm

PPLLSSS i need Help!!!!

http://www.faa.gov/documentLibrary/medi ... -25-15.pdf

Site: 317
I need many people who helo me to make the pdf into an CSV File:

Code: Select all

AAA AVICON AVIATION CONSULTANTS & AGENTS PAKISTAN -
into:

Code: Select all

AAA,AVICON AVIATION CONSULTANTS & AGENTS,PAKISTAN,

It work only by Hand line for line. :D

So if someone want help please tell me i dont want have some double work.
:!: :!: :!: I search for People who want exchange VRS Data. I life near LOWW and i have a huge Coverage and multiple Receiver. :!: :!: :!:
My newest Project: http://www.publictransportforum.at/

agw
Posts: 1883
Joined: Fri Feb 17, 2012 3:20 am

Re: 3ltr code from us gov -> help building an huge list

Postby agw » Sat Nov 14, 2015 2:46 pm

Extracting text from PDF can be a pain, the text blocks in the PDF don't necessarily line up with the order in which you read them so you can get chunks of text out of order, or joined up with adjacent blocks and so on.

You could try PDFToText (https://en.wikipedia.org/wiki/Pdftotext) but my results were mixed at best when I used it.

loww
Posts: 86
Joined: Sun Jun 28, 2015 10:55 am
Location: LOWW
Contact:

Re: 3ltr code from us gov -> help building an huge list

Postby loww » Sat Nov 14, 2015 2:47 pm

i do it by hand.
its very simple.
The first 3 letter are the code and in the middle is the country. all country will replaced with "country name" and so i got an readable list.

But it takes time and sucks....
:!: :!: :!: I search for People who want exchange VRS Data. I life near LOWW and i have a huge Coverage and multiple Receiver. :!: :!: :!:
My newest Project: http://www.publictransportforum.at/

egpd1701
Posts: 43
Joined: Fri Nov 08, 2013 3:39 pm

Re: 3ltr code from us gov -> help building an huge list

Postby egpd1701 » Mon Feb 01, 2016 12:50 pm

If your still looking, I've got the csv, you'll need to clean it up but its done if you want it.

loww
Posts: 86
Joined: Sun Jun 28, 2015 10:55 am
Location: LOWW
Contact:

Re: 3ltr code from us gov -> help building an huge list

Postby loww » Mon Feb 01, 2016 2:52 pm

thx i make it myself.
:!: :!: :!: I search for People who want exchange VRS Data. I life near LOWW and i have a huge Coverage and multiple Receiver. :!: :!: :!:
My newest Project: http://www.publictransportforum.at/


Return to “Routes”

Who is online

Users browsing this forum: No registered users and 1 guest