1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

scrapebox link edit

Discussion in 'Black Hat SEO Tools' started by blissbliss, Jun 25, 2017.

  1. blissbliss

    blissbliss Junior Member

    Joined:
    May 6, 2017
    Messages:
    164
    Likes Received:
    24
    Gender:
    Male
    Occupation:
    make shitty pbn that won't rank shit :D
    Location:
    Thailand
    Yesterday I see thread that share some udemy online course with code to redeem paid course for free.I just know this way to get free couse first time so I search google and I see the url on some website and I get an idea so I use scrapebox to havest.My purpose is to get all free code that can use in udemy.I use footprint site:udemy.com inurl:?couponCode= guest what it's work~ .Now my problem is I want to delete the word after code &site.......... I want to delete all of them because I can't manual it .It's alot .How can I delete it once any one can help me ?

    [​IMG]

    I use this footprint
    [​IMG]
     
  2. blissbliss

    blissbliss Junior Member

    Joined:
    May 6, 2017
    Messages:
    164
    Likes Received:
    24
    Gender:
    Male
    Occupation:
    make shitty pbn that won't rank shit :D
    Location:
    Thailand
    wow I know how to do this thx to google

    =SUBSTITUTE(REPLACE(REPLACE(A3,1,IFERROR(FIND("//",A3)+1,0),TEXT(,))&"/",FIND("/",REPLACE(A3,1,IFERROR(FIND("//",A3)+1,0),TEXT(,))&"/"),LEN(A3),TEXT(,)),"www.",TEXT(,))
     
  3. blissbliss

    blissbliss Junior Member

    Joined:
    May 6, 2017
    Messages:
    164
    Likes Received:
    24
    Gender:
    Male
    Occupation:
    make shitty pbn that won't rank shit :D
    Location:
    Thailand
    shit it's not work Can anyone help me with excell formular