Forum Discussion
Solved
Get an extract of the source web address to appear in a power query
Hi, i would very much appreciate if anyone can help with something that i thought would have been possible but i am having no luck achieving it. i run a power query that gets data from the web from...
You may extract city from URL as
city = Text.AfterDelimiter( getAddress04, "/", {0, RelativePosition.FromEnd} )and add the value to custom column
You may extract city from URL as
city = Text.AfterDelimiter( getAddress04, "/", {0, RelativePosition.FromEnd} )and add the value to custom column
- thanks for reply sergie.
should i just open up the advanced editor in the power query and put your code in the next line at the bottom ?- Ive done it - thanks so much for you help segie !!!!!
stever78 , you are welcome.
Yes, that's with advanced editor.