Forum Discussion

Brass Contributor

Jun 27, 2022

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...

excel question vba paste.xlsm19 KB

excel

SergeiBaklan
Jun 27, 2022
stever78

You may extract city from URL as

city = Text.AfterDelimiter( getAddress04, "/", {0, RelativePosition.FromEnd} )

and add the value to custom column
Get Address to appear in PQ.xlsm18 KB

stever78

Brass Contributor

Jun 27, 2022

stever78

I HAD ATTACHED THE WRONG DOCUMENT, PLS FIND CORRECT EXCEL FILE

Get Address to appear in PQ.xlsm17 KB

SergeiBaklan
Diamond Contributor
Jun 27, 2022
stever78

You may extract city from URL as

city = Text.AfterDelimiter( getAddress04, "/", {0, RelativePosition.FromEnd} )

and add the value to custom column
Get Address to appear in PQ.xlsm18 KB
- stever78
  Brass Contributor
  Jun 27, 2022
  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 ?
  - stever78
    Brass Contributor
    Jun 27, 2022
    Ive done it - thanks so much for you help segie !!!!!