Table of Contents | ||||||
---|---|---|---|---|---|---|
|
...
from my.upload.sample.data
select split(message, ";", 8) as geocoordStrings
...
We want to represent the strings in the geocoordStrings column in the format :type:value. First, we must transform the strings to data type geocoord.
Step 1: Transform the geocoord strings into data type geocoord
...
reprgeo(geocoord)
reprgeo(geocoord(string))
Example
You must have uploaded the following CSV file to your Devo domain as explained above to try out the following example.
View file | ||
---|---|---|
|
Copy the following LINQ script and try the above example on the my.upload.geolocation.data
table.