Forum Discussion
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...
eliasayyy
Memorable Member
Memorable Memberhello goober04 in power query go to add columns and choose new custom column
type in
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
Appreciate the quick response eliasayyy . Tried it and this is the result. What am I missing here?
- eliasayyy
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
