Forum Discussion
Kasia123
3 years agoNew Member
Get data from URL adres which contains #
Hi,
I am trying to read the data from URL which contains # - example: https://makeup.pl/categorys/23466/#offset=36
In this case my query reads only the first part of adres up to # which is https://makeup.pl/categorys/23466.
My source is the following:
Source = Table.FromColumns({Lines.FromBinary(Web.Contents("hhttps://makeup.pl/categorys/23466/#offset=36"))})
How could I modify the code to read the whole page in adress?
1 Reply
- ppm1Solution Sage
Try replacing # with #(#).
Chris Webb's BI Blog: Character Escape Sequences In M (crossjoin.co.uk)
Pat