+ Reply to Thread
Results 1 to 5 of 5

Formula to find the second jpg URL from the HTML script

  1. #1
    Registered User
    Join Date
    06-20-2015
    Location
    Chennai, India
    MS-Off Ver
    2010
    Posts
    59

    Formula to find the second jpg URL from the HTML script

    Kindly help me to find the second jpg URL (highlighted) from the below HTML script. To get the first jpg URL i have used the following formula, but finding very difficult to find the second URL.

    first jpg url = =MID(A1,FIND("https",A1),(FIND(".jpg",A1,FIND("https",A1))-FIND("https",A1))+4) = https://scontent.cdninstagram.com/hp...67034004_a.jpg

    second jpg url = ??? = https://scontent.cdninstagram.com/hp...70335126_n.jpg
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-20-2015
    Location
    Chennai, India
    MS-Off Ver
    2010
    Posts
    59

    Re: Formula to find the second jpg URL from the HTML script

    Anyone could u pls help me on this question

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,508

    Re: Formula to find the second jpg URL from the HTML script

    You can basically use the same formula, but instead of looking directly at A1 you want to look at A1 with the contents of B1 removed from it - you can achieve that by using SUBSTITUTE. Try this formula in C1:

    =MID(SUBSTITUTE(A1,B1,""),FIND("https",SUBSTITUTE(A1,B1,"")),(FIND(".jpg",SUBSTITUTE(A1,B1,""),FIND("https",SUBSTITUTE(A1,B1,"")))-FIND("https",SUBSTITUTE(A1,B1,"")))+4)

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    06-20-2015
    Location
    Chennai, India
    MS-Off Ver
    2010
    Posts
    59

    Re: Formula to find the second jpg URL from the HTML script

    thanks a lot for your help... you are truely awesome...

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,508

    Re: Formula to find the second jpg URL from the HTML script

    Glad to help - thanks for the rep.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 09-27-2014, 04:48 PM
  2. [SOLVED] Excel VBA - Script Post html source code in cells
    By lafanker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2014, 12:45 AM
  3. Replies: 24
    Last Post: 05-14-2014, 02:41 AM
  4. Script loop - get data from html table
    By Rawland Hustle in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 10-02-2012, 02:32 PM
  5. How to speed up the script below if i have 10000 ip, loop 5000 times on .html page
    By micnie2020 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2012, 01:54 PM
  6. VBA find script
    By nygwnj in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-11-2009, 10:36 PM
  7. VBA Script. Find & Replace.
    By denis.samoilov in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2008, 11:14 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1