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

Looking for a Scrapebox or Excel solution

Discussion in 'BlackHat Lounge' started by flc735, Feb 28, 2013.

  1. flc735

    flc735 Regular Member

    Joined:
    Apr 30, 2011
    Messages:
    284
    Likes Received:
    82
    Occupation:
    Writer
    Location:
    Los Angeles, CA
    I am pretty good with scrapebox and excel. I can usually figure these things out but I am a bit stuck on this one.

    Is there a way to make two different %kw% tags to use with scrapebox's merge function?

    For example...
    My keywords are apples and grapes

    My footprints are
    Code:
    red and yellow %kw1%
    purple %kw2%
    are there purple %kw1% or red %kw2%
    Basically, I want the '%kw1%' tag to only insert the word 'apples' and the '%kw2%' tag to only insert the word 'grapes' so that the output produces specifically...
    Code:
    'red and yellow apples'
    'purple grapes'
    'are there purple apples or red grapes'
    %kw1% and %kw2% are not actual tags, I just used them to explain my problem. Are there any tags that would work? If not, can you think up an Excel idea?
     
  2. flc735

    flc735 Regular Member

    Joined:
    Apr 30, 2011
    Messages:
    284
    Likes Received:
    82
    Occupation:
    Writer
    Location:
    Los Angeles, CA
    I'll try a bump. I think I am going to have to learn Excel macros :(
     
  3. gaabrielz

    gaabrielz Registered Member

    Joined:
    Nov 17, 2008
    Messages:
    60
    Likes Received:
    35
    Occupation:
    Application Developer
    Location:
    Canada
    I don't know much about Scrapebox but you are basically looking for a find and replace ? Notepad/Excel can do this...
    Seems to simple to me, maybe I'm missing something...
     
  4. flc735

    flc735 Regular Member

    Joined:
    Apr 30, 2011
    Messages:
    284
    Likes Received:
    82
    Occupation:
    Writer
    Location:
    Los Angeles, CA
    I have 50,000 variations of the word 'apples' and 50,000 variations of the word 'grapes'. Also, my 'phrase to insert my keywords in' is much larger as well.
    So I couldn't do a find and replace with Excel, or else I would have to repeat it 50,000 times.
    Scrapebox can do this with a single keyword, I was hoping to find a way to do it with two different keywords.
     
  5. gaabrielz

    gaabrielz Registered Member

    Joined:
    Nov 17, 2008
    Messages:
    60
    Likes Received:
    35
    Occupation:
    Application Developer
    Location:
    Canada
    Ohhh I understand. You could do it in Excel with basic VBA knowledge (just record a macro and edit it to fit your needs).
    Maybe there is a way to do it in Scrapebox, someone else might be able to answer ! :)
     
  6. flc735

    flc735 Regular Member

    Joined:
    Apr 30, 2011
    Messages:
    284
    Likes Received:
    82
    Occupation:
    Writer
    Location:
    Los Angeles, CA
    Yup, that's what I think I will have to do. Thanks.