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

Bulk create txt files each with two different phrases(keyword,url)

Discussion in 'Black Hat SEO' started by aidenhera, May 20, 2017.

  1. aidenhera

    aidenhera Elite Member

    Joined:
    Nov 30, 2016
    Messages:
    1,595
    Likes Received:
    276
    Gender:
    Male
    I have some bot that didnt let me do customization, however ive found a workaround.

    I cant have all kws in one file or they will all be attributed to one created web20s. However If I choose directory with txt files each having 2 keyword then it will do the job.


    Question is, how to do this quickly in bulk? i will repeat this process over and over, i USED scrapebox text split tool but

    each text file is supposed to have code like that line:

    somecode keyword somecode url somecode

    and with scrapeboox tool i can do only one of these at once - I use some free service textmechanic called "append suffix/prefix" so i can basically take a list of kws and append code on the front and on the back, but i cant append different urls to that with any tool i know.

    clues?
    i want to do

    somecode keyword1somecode url 1somecode
    somecode keyword 2somecode url 2somecode
    somecode keyword3 somecode url 3somecode

    in bulk having kw list and url list but i cant seem to merge it...
     
  2. Shaunm

    Shaunm Jr. VIP Jr. VIP

    Joined:
    Mar 27, 2014
    Messages:
    1,770
    Likes Received:
    860
    Home Page:
    Not 100% sure I understand your goal but a spreadsheet maybe able to do it using the & feature as shown in the screenshot below.

    [​IMG]


    Will produce .....

    [​IMG]

    Just make a cell to the far right of the final "somecode" column and put the & forumla in there and it should work.
     
    • Thanks Thanks x 1
  3. bartosimpsonio

    bartosimpsonio Jr. VIP Jr. VIP Premium Member

    Joined:
    Mar 21, 2013
    Messages:
    12,026
    Likes Received:
    10,816
    Occupation:
    WHEREZ MA
    Location:
    BITCOINS AT?
    Home Page:
    You know some Perl? Python? This can be done fairly quickly. If you wanna PM me your contact I'll do this for you for free.
     
    • Thanks Thanks x 1
  4. aidenhera

    aidenhera Elite Member

    Joined:
    Nov 30, 2016
    Messages:
    1,595
    Likes Received:
    276
    Gender:
    Male
    Thanks a lot ive done it in excel already like @Shaunm said. Forgot totally about how functional excel is.