Extract Data From A URL Using Google Sheets

Question

I am trying to extract data from a URL that is in a single cell in google sheets. The data in the cell is:

https://www.aliexpress.com/item/2017-SKMEI-Outdoor-Sports-Compass-Watches-Hiking-Men-Watch-Digital-LED-Electronic-Watch-Man-Sports-Watches/32790079639.html?spm=a2g01.8286187.3.1.3fa025c4ONMmXB&scm=1007.14594.99248.0&scm_id=1007.14594.99248.0&scm-url=1007.14594.99248.0&pvid=bff55205-e331-4c05-9e04-6e8c1a660f0f

From the URL I need to extract the number: 32790079639

Is there a way collecting this information?

Thanks!

bren · Accepted Answer · 2018-05-08 13:58:35Z

1

You can use the function =REGEXEXTRACT to achieve this goal. This function uses a regular expression to extract a substring from the input. For example,

=REGEXEXTRACT(A1, "([0-9]+)\.html")

A full example here

answered May 8, 2018 at 13:58

bren

4,3503 gold badges30 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Max Makhrov · Accepted Answer · 2018-05-08 14:00:29Z

1

=REGEXEXTRACT(A1,"([^/]*)\.html")

A1 is text with your URL.

[^/]* -- any text, not /,
(...) -- to capture gruop

edited May 8, 2018 at 14:00

answered May 8, 2018 at 13:58

Max Makhrov

18.9k6 gold badges65 silver badges88 bronze badges

1 Comment

bren Over a year ago

You'll want to escape the . in your expression; By default, . matches any character that's not newline

Collectives™ on Stack Overflow

Extract Data From A URL Using Google Sheets

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related