XPathOnUrl using Substring()

Hey there,
Coding beginner here. I tried to use the XPathOnUrl to retrieve part of a string using Substring(), however I can't seem to get anything other than an Excel #VALUE error.


<!DOCTYPE html>
<html lang="en-gb" class="no-js logged-in client-root">
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">

Peter was here


Excel Formula that I'm using:

Now, retrieving the whole string using "/html/head/title" is working using XPathOnUrl, however, when adding Substring() an error appears. Did I make a mistake in my XPath?

Let me know if you need any additional info. I appreciate any help!

Hi, I don't believe substring is supported as an operator within the XPathOnUrl argument. Perhaps try to use the built in Excel string functions such as Left()?