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
Summing the values of a variable WITHOUT taking into the frequencyHello all, Following on from https://www.statalist.org/forums/for...ir-frequencies, I did the follo…
BacktestingHi everyone, I am trying to run a backtesting model for the data I have. I am not an expert with st…
Transition MatrixHello, I am trying to generate a transition matrix of the change in the employment status of individ…
Autocorrelation and Heteroskedasticity in panel data using fixed effect modelHello everyone, I'm currently facing a common issue in panel data regression. I'm doing empirical re…
Exporting Descriptive Statistics using proportion (%) for multinomial results into excelI would appreciate some advice on how to use a short cut (if there is one!) as the put excel command…
Subscribe to:
Post Comments (Atom)
0 Response to Replace odd commas by spaces in a variable
Post a Comment