M
M
Mr.2020-04-20 21:31:24
Google Sheets
Mr., 2020-04-20 21:31:24

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

1 answer(s)
A
Alexander Ivanov, 2020-04-21
@oshliaer

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 question

Ask a Question

731 491 924 answers to any question