Answer the question
In order to leave comments, you need to log in
Why does the code define a different number?
=REGEXEXTRACT( INDEX(IMPORTHTML(N14;"table";0);2;1); ".*?\-.*?(\d+)" )
This code should show the number 85 and it shows the number 1 how to fix it code site link N14 https://readmanga.me/ia_korol_volshebnik
On other sites of this domain, well, how they work 1 to 20 such a problem
The same problem with the words Extra and Prologue, it shows the number 1
Answer the question
In order to leave comments, you need to log in
We need to strengthen the regular expression a little - replace it with ".*?\d+\s*\-.*?(\d+)"
.
=REGEXEXTRACT(INDEX(IMPORTHTML(N14;"table";0);2;1);".*?\d+\s*\-.*?(\d+)")
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question