Xpath Dump with substring-after

Support
#1

Hi to all, hi have a problem:

I want dump part of text after one specific word.
The problem is one cell of excel contain max 32,767 char,
So is impossible for me grab entire description and extract part of text with excel formula because the text after dump is cut by excel.

So i search in google and i see a special formula for xpath called: substring-after
example is here:

https://stackoverflow.com/questions/333249/how-to-apply-the-xpath-function-substring-after

So i need extract for example from here:

https://www.pinascostore.com/dl-200/2180-accensione-flytech-lambretta-cono-piccolo.html?search_query=28356880&results=1

The description parts: //*[@class="rte"]
But i need extract the text after the word: "Applicazioni:"

Some idea for apply this formula "substring-after" in this tool for excel?

#2

Hi,

I don't believe substring-after is supported by the XPath integration used in SeoTools. However, perhaps you can use RegexpFind to get the substring before it reaches the cell?

image

#3

Yes i tryed and that work.. but don't work when what u dump in the cell is over 32,767 char.. and the text u need is near the end lmao :smile:

#4

Can't you use a regex to extract the final part of the string? So it doesn't exceed 32K chars.

#5

This does not appear to be close to 32K chars, or am I missing something? :slight_smile:

image
image.png701×363 58.4 KB