<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "alternate-country-code with trailing comma"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/8.page</link>
		<description><![CDATA[Latest messages posted in the topic "alternate-country-code with trailing comma"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>alternate-country-code with trailing comma</title>
				<description><![CDATA[ 3 Switzerland entries have a trailing comma in their alternate country code (CH,):
2661349 Buchs
7285374 Buchs (SG)
7303718 Guscha

Can the comma be eliminated? Ignoring it makes the import to postgres as array (embed in {}) a little complicated.

Dealing with the alternate country codes I was wondering why about 200 thousand entries exist with their alternate country code being exactly their normal country code, while all other entries (except those with a different or with multiple alternate codes) just have a null value? Just in case there is a special reason for that I would like to know!

All the best
Andreas]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/39764.page#52681</guid>
				<link>http://forum.geonames.org/gforum/posts/list/39764.page#52681</link>
				<pubDate><![CDATA[Sat, 5 Nov 2022 09:52:11]]> GMT</pubDate>
				<author><![CDATA[ femalepressure]]></author>
			</item>
			<item>
				<title>Re:alternate-country-code with trailing comma</title>
				<description><![CDATA[ I have removed the commas, set the equal countrycodes to null and added a processing step in the modify function to do this for updates.

Best Regards

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/39764.page#52690</guid>
				<link>http://forum.geonames.org/gforum/posts/list/39764.page#52690</link>
				<pubDate><![CDATA[Sat, 5 Nov 2022 21:15:32]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>alternate-country-code with trailing comma</title>
				<description><![CDATA[ Thank you very much Marc!]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/39764.page#52693</guid>
				<link>http://forum.geonames.org/gforum/posts/list/39764.page#52693</link>
				<pubDate><![CDATA[Mon, 7 Nov 2022 09:33:18]]> GMT</pubDate>
				<author><![CDATA[ femalepressure]]></author>
			</item>
	</channel>
</rss>