Forum Discussion
Dunner2020
Post Prodigy
Post ProdigySplitting column in X & Y coordinates
Hi there, One of my tables in power BI is connected with a ArcGIS. That table has column which looks like following: SHAPE POINT (1407236.9840000002 4920485.674) POINT (1407116.93900000...
Dunner2020 , I think first you should replace
"POINT (" with ""
and ")" and ""
and then split the this by " " (Space) in two columns.
You have option for both in power query/edit query
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
https://www.howtoexcel.org/power-query/bulk-replace-values/
amitchandak
Super User
Super UserDunner2020 , I think first you should replace
"POINT (" with ""
and ")" and ""
and then split the this by " " (Space) in two columns.
You have option for both in power query/edit query
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
https://www.howtoexcel.org/power-query/bulk-replace-values/