How to remove image dimensions from urls that are in a Excel Column?

[brvnbld]

Hi there, I have a long list of Image urls in a column all which have image dimensions, for example https://example.com/wp-content/uploads/2022/07/sample-image-300x212.jpg . I need to remove everything that dimensions 300x212, these dimensions vary. I thought I can replace this -*x, with x and then x*. so that all those get deleted. But the replace sees the first "-", so it didn't work. The image urls also have other extensions like webp etc.

 

[Domenic]

Actually, I think you'll run into problems with it. Try something like this instead...

    Dim url As String
    url = "https://example.com/wp-content/uploads/2022/07/sample-image-300x212.jpg"
   
    Dim exts As Variant
    exts = Array(".webp", ".jpg", ".png")
   
    Dim isImage As Boolean
    isImage = False
   
    Dim i As Long
    For i = LBound(exts) To UBound(exts)
        If LCase(url) Like LCase("*-###x###" & exts(i)) Then 'compare using search pattern
            url = Left(url, InStrRev(url, "-") - 1) & exts(i)
            isImage = True
            Exit For
        End If
    Next i

    If isImage = True Then
        MsgBox url, vbInformation
    Else
        MsgBox "No image file name found!", vbExclamation
    End If