How to create wkt column from coordinates of LineString ? (generic solution for shape type)

Hi @ikubra800

Did you try to use the stringsearch?

Do you want to separate lat and long, correct?

Thanks in Advance,

Danilo

Your attribute coordinates reads like:

[x1,y1][x2,y2][x3,y3][x4,y4]

WKT for a linestring has the following format:

LINESTRING (x1 y1, x2 y2, x3 y3, x4 y4)

So perform a bit of consecutive search-and-replace:

1. Replace ',' (comma) with ' ' (space)
2. Replace '][' with ', ' (comma space)
3. Replace '[' with 'LINESTRING ('
4. Replace ']' with ')'

Thanks for response @danilo_fme​  and @geomancer​ ,

I solved that GeoJSON (Geographic JavaScript Object Notation) reader directly.

Hi @ikubra800​ 

Thanks your feedback. It is a very good that you solved the problem with the GeoJSON Reader.