Skip to main content
3 events
when toggle format what by license comment
Sep 19, 2023 at 0:31 comment added Rubén - Volunteer Moderator - @Catalyx I think that the problem is that IMPORTXML can't be included in the output of functions like concat, but it could be used for filtering. Considering this, it might be not precise to say that IMPORTXML doesn't support concat, it might be more precise to say that it doesn't fully support xPath 2.0. Anyway, the point is that IMPORTXML can't use all the XPath expressions.
Sep 18, 2023 at 23:00 comment added Catalyx Yes, the documentation for Google Sheets doesn't make clear which XPath version is used though it seems v1.0. I understand the concat expression I used is v2.0. From asking around, v1.0 doesn't seem to support returning the element names either. so a custom function may be the only alternative at the moment when the data are only in XML.
Sep 18, 2023 at 19:15 history answered Rubén - Volunteer Moderator - CC BY-SA 4.0