Forum Discussion
Formula for replacing values
Hi everyone,
I'm trying to pull longitude and latitude data from a ship-tracking website and create the "map" visualization based on it:
https://www.myshiptracking.com/vessels/deepsea-yantai-mmsi-311000483-imo-9731638
And it comes in this format after some manipulation with columns:
Since the coordinates will be changing, I guess I need a formula that will be automatically converting this text into the decimal number (without the deg symbol °) each time I refresh the data. It should look like this I guess:
What would the fomula be? And do I replace the text with this formula or do I create a new column?
Thanks in advance 🙂
In Power Query, select each column and do a Replace Values to replace your degree symbol with blank. Or, you could do a essentially a Left of length - 1 in a new column.
3 Replies
In Power Query, select each column and do a Replace Values to replace your degree symbol with blank. Or, you could do a essentially a Left of length - 1 in a new column.
Were you all able to get this working? I'm doing something similar, and I'm experiencing a weird issue where it seems like ReplaceValue can't find the ° symbol. I've copied and pasted it exactly like it is in Power Query but it isn't finding this character.
Have you all seen anything like this?
