String Split (Regex): Split Chinese Characters from String

Hi everyone,

I was looking for geo data (longitude & latitude) for Chinese cities to create a map in PowerBI. I found a dataset on Geonames: GeoNames

I’m interested in the field “alternatenames” which contains the city names in Chinese. The data there looks like this:

Kanbaduo,Oiser,Oisêr,Wosai,Wosai Xiang,kan ba duo,wo sai,wo sai xiang,坎巴多,窝塞乡,窝赛

I’ve been trying to utilize the node String Splitter (Regex) to separate the Chinese names from the rest, but no Regex code I tried worked so far. The desired output would be 2 columns, one for the Chinese names and one of the remaining alternate names:

| Rest                                                                  | Chinese    |
| Kanbaduo,Oiser,Oisêr,Wosai,Wosai Xiang,kan ba duo,wo sai,wo sai xiang | 坎巴多,窝塞乡,窝赛 |

Any tips on how to write the Regex code for this?

Best,

Eren