Search code examples
csvnotepadgtfs

Why does my GTFS data contain "invisible" line breaks?

So I've been looking at a way to import GTFS data into an SQLdb for my application. I found a solution available on GitHub.

But, this is written using python. I don't think I can use this directly in my windows application. Please correct me if I am wrong here.

But I have no issues with understanding the logic behind the solution and creating my own 'parser'.

So, I opened the GTFS data file "calendar dates.txt" on Notepad and found its content confusing. It was like:

service_id,date,exception_type1,20151012,11,20151111,12,20150822,12,20150829,12.....

You can see that its confusing when there are no line breaks. But I paste the code here to show it to you guys, and it automatically formats to:

service_id,date,exception_type
1,20151012,1
1,20151111,1
2,20150822,1
2,20150829,1
2

Now it clearly makes sense!! (There are spaces in between for parsing)..

But I don't understand. Is Notepad showing it wrong? How do I see the data "properly" then, in order to write my own parser?

Solution

  • First of all copy your related GTFS(routes,shaps etc) and than paste in an online text editor(for example: http://www.editpad.org/)

    And than copy from this online text editor and paste again to your original .txt.