Hi,
Thanks in advance for your help. Maybe, what I am going to ask is an easy question for many of you but I have been unable to find a solution. Sorry in that case!!!
I have a var (GEOMETRY) that I need to change replacing odd commas by an space. In this example, I am trying to replace this value:
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GEOMETRY |
|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
1. | MultiPolygon(((232840.245027644, 4143512.94418335, 233025.149040326, 4143497.94213052, 233137.343532, 4143913.93358042, 233082.751561214, 4143979.93295409, 233074.45.. |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
By this value:
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GEOMETRY |
|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
1. | MultiPolygon(((232840.245027644 4143512.94418335, 233025.149040326 4143497.94213052, 233137.343532 4143913.93358042, 233082.751561214 4143979.93295409, 233074.45.. |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
As you can see, every two commas (starting by the first one) should be replaced by a space or deleted (it is the same for me). But I don not know how to do it.
What I am intending is to adapt a system (used in Oracle Space) by other one (used in QGIS, WKT). That is the reason why I need this replacing.
Thanks a lots
Juan Miguel Gómez.
Related Posts with Replace odd commas by spaces in a variable
Two ID variables for each rowHey all, In advance would like to say sorry for experienced users for asking this (just cannot find …
Converting DMS coordinates to decimal in StataHi! Can someone please tell me if it's possible to convert DMS coordinates to decimal in Stata? I am…
stcox: Continuous Time Varying CovariatesWhen evaluating the effect of a continuous covariate that changes from one wave to the next, (in thi…
how to split datae and timedateofvisit 1/25/2020 1:02 1/12/2020 11:55 variable type double. how can i split date and time in to…
Blinder-Oaxaca Decomposition with group specific variablesI would like to run a Blinder-Oaxaca Decomposition on black-white differences. I have panel data whe…
Subscribe to:
Post Comments (Atom)
0 Response to Replace odd commas by spaces in a variable
Post a Comment