Is it possible to trip only specific lines in google sheet importhtml function

Question

I am trying to fetch market price from a website using importhtml & It comes in rows & columns,

=IMPORTHTML("https://www.moneycontrol.com/commodity/gold-price.html", "table", 3)

Answer for the same is multiple columns

I am able to edit it even further using the below.

=INDEX(IMPORTHTML("https://www.moneycontrol.com/commodity/gold-price.html", "table", 3), 1, 1)

But the result of the above is this in one single cell.

"Sep 15, 15:06 49814.00-204.00 (-0.41%)"

Is it possible to get only 49816?

Answer 1

Use regexextract(), like this:

=value( 
  regexextract( 
    importhtml("https://www.moneycontrol.com/commodity/gold-price.html", "table", 3), 
    ":\d+\s+(\d+)" 
  ) 
)