D
D
Dima2022-01-03 19:13:44
Google Sheets
Dima, 2022-01-03 19:13:44

How to parse price value in Google Sheet?

I can't get the price value on this site into the table, I get an error:
Imported content is empty.

Other elements, for example, headers, are copied perfectly. Here is a link to the table.

The price value is in the element's attributes, they put a JSON array there where this price appears, are there any options to pick it up from there?

61d3209b3cea5932034032.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2022-01-04
@qpz

=+REGEXEXTRACT(A1,"""price""\:""([\d\.]+)""")

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question