Forum Discussion

goober04's avatar
goober04
New Member
3 years ago

first time user power query extracting text from URL into column

hello all,   new user. super limited programming knowledge. first time on forums (advice appreciated if going about it wrong)   I have a URL query in PowerBI (https://websiteurl/api/thisisthetext...
Need Help
goober04's avatar
goober04
New Member
3 years ago

Appreciate the quick response eliasayyy . Tried it and this is the result. What am I missing here?

eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

try this 

let
    fullURL = [url],  // Get the full URL from the current row
    extractedText = Text.Middle(fullURL, 23, Text.PositionOf(fullURL, "/01") - 23)  // Extract the desired substring
in
    extractedText