GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
allCountries - 5387 records are missing a tab delimiter or new line character  XML
Forum Index -> General
Author Message
shobeck



Joined: 27/10/2017 19:56:47
Messages: 1
Offline

I've just loaded the most recent allCoutnries file into a Postgres table. It successfully loaded 11083858 rows and errored on 5387 rows. The errors were mostly "expected: value separator (\t)" and some were listed as "expected: record separator (\n)".

I would rather not go through all 5387 rows individually to see where the missing tab is.

Example rows are: 2747, 3394, 3407, 5156, 5544, 5698, 5757, 14393, 20148... (plus a whole lot more!)

Any recommendations to get these remaining records loaded?

Thanks!

-shobeck
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team