double country causes problem in export for United Kingdom locations
Original issue 146 created by adam_winer on 2014-01-19T21:38:45.000Z:
<b>What steps will reproduce the problem?</b> 1.full export 2.import in Excel, do "text to columns" 3.country (i.e. England) does not appear in column State/Province but in column location 1, texts of location 1 is found in location 2
<b>What is the expected output? What do you see instead?</b> Text of of location should remain in location <b>What version of the product are you using? On what operating system?</b>
10.1.2 Windows XP (32bit) <b>Please provide any additional information below.</b>
I have 26000 sightings in the databse with 50+ countries, problem is only with UK. I attach sample csv. Excellent program btw, very happy user
Comments (2)
-
reporter -
reporter Comment #2 originally posted by adam_winer on 2014-01-22T01:33:46.000Z:
Fixed in revision 825.
- Log in to comment
Comment #1 originally posted by adam_winer on 2014-01-20T06:50:40.000Z:
Yes, well diagnosed. It's exactly the issue of having a country-inside-another-country that makes the output incorrect. Marking England down as "State/Province" is hardly perfect, but it's far better than demoting it to a plain "Location"!