What is the formula in Excel / Google Sheets to clear links from extra characters?

I

iminby2021-06-10 16:46:37

excel

iminby, 2021-06-10 16:46:37

In general, there is a cell, in it, comma-separated links to images of the form

https://site.by/img.jpg?534343,https://site.by/img2.jpg?888888

How to process a large number of lines in excel to clear links to images from the question mark and numbers after it?
Who can tell the correct expression, for example, if you use REGEXEXTRACT in Google spreadsheets

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

Grigory Boev, 2021-06-10
@iminby

REGREPLACE will help here ( text; regular_expression; replacement )
=ArrayFormula(REGEXREPLACE(A1:A;"\?\d+";""))
Here is a link to a demo table