Looking for a Scrapebox or Excel solution

flc735

Regular Member
Joined
Apr 30, 2011
Messages
285
Reaction score
82
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?
 
I'll try a bump. I think I am going to have to learn Excel macros :(
 
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...
 
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...
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.
 
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 ! :)
 
Ohhh I understand. You could do it in Excel with basic VBA knowledge (just record a macro and edit it to fit your needs).
Yup, that's what I think I will have to do. Thanks.
 
Back
Top