Is There Any Tool That Can Do This?

acamso said:

I don't know of a specific tool, but I can do this for you. Just send me a PM.

Click to expand...

<?php
//variables
$filename = "data.csv"; // the file must stay in the same folder where the script is
$folder = dirname(__FILE__);
$data = $string = NULL;
// read the file
$fp = @fopen($folder."/".$filename, "r");
if(empty($fp))
throw new Exception("file could not be read");
//write string
while($data = fgetcsv($fp)){
$string .= "<a href=\"{$data[1]}\">{$data[0]}</a> ";
}
// print result
echo htmlentities($string);

Click to expand...

nesterdwarf said:

Code:

http://www.sendspace.com/file/6c5ncz

Code:

https://www.virustotal.com/en/file/d3a480670aeeea52c387e67f63bec38ba6d0c35b096aca93773a3ee1a29fe4f5/analysis/1369475716/

Coded this up for you in WinAutomation. All you have to do is save your file out of Excel as a .csv, run 'lol-blaster.exe', select the exported .csv and it will output a text file in the same location with the data like you specified. I've included a sample .csv file to show you how it works, and the .waj file in case you want to load it up in WA and see what it does.

HTH
ND

Click to expand...

astronaut23 said:

I'm not sure about this one, but TextMechanic.com has a lot of similiar tools. I use them all the time. They have permutation generators, randomizers, text combiners etc. Check it out, maybe you'll find what you need.

Click to expand...

g0g0l said:

You can do it easily by PHP. I have coded this for you. You need to place your csv file in the same folder (named data.csv .. change it if necessary)

Click to expand...

Panther28 said:

use =CONCATENATE

Click to expand...

LOL-Blaster said:

Ah, that's not what I want. I need a bot to make 3x3 combination of the hyperlink

Click to expand...

<?php 
//vars
$filename = "data.csv"; // the file must stay in the same folder where the script is
$folder = dirname(__FILE__);
$data =  $array = $string = NULL;

//function

function array_cartesian() {
    $_ = func_get_args();
    if(count($_) == 0)
        return array(array());
    $a = array_shift($_);
    $c = call_user_func_array(__FUNCTION__, $_);
    $r = array();
    foreach($a as $v)
        foreach($c as $p)
            $r[] = array_merge(array($v), $p);
    return $r;
}

// read the file
$fp = @fopen($folder."/".$filename, "r");
if(empty($fp))
    throw new Exception("file could not be read");
//read from csv
while($data = fgetcsv($fp)){
    $array['url'][] = $data[0];
    $array['anchor'][] = $data[1];
}

$array_new = array_cartesian($array['url'] ,$array['anchor'] );
//print_r($array_new);

foreach($array_new as $new){
    $string .= "<a href=\"{$new[1]}\">{$new[0]}</a>  ";
}


// print result
echo htmlentities($string);

name1,url1
name2,url2
name3,url3
name4,url4
name5,url5

g0g0l said:

LOL sorry I also misunderstood your question! I have recoded the PHP script for generating combinations

Code:

<?php 
//vars
$filename = "data.csv"; // the file must stay in the same folder where the script is
$folder = dirname(__FILE__);
$data =  $array = $string = NULL;

//function

function array_cartesian() {
    $_ = func_get_args();
    if(count($_) == 0)
        return array(array());
    $a = array_shift($_);
    $c = call_user_func_array(__FUNCTION__, $_);
    $r = array();
    foreach($a as $v)
        foreach($c as $p)
            $r[] = array_merge(array($v), $p);
    return $r;
}

// read the file
$fp = @fopen($folder."/".$filename, "r");
if(empty($fp))
    throw new Exception("file could not be read");
//read from csv
while($data = fgetcsv($fp)){
    $array['url'][] = $data[0];
    $array['anchor'][] = $data[1];
}

$array_new = array_cartesian($array['url'] ,$array['anchor'] );
//print_r($array_new);

foreach($array_new as $new){
    $string .= "<a href=\"{$new[1]}\">{$new[0]}</a>  ";
}


// print result
echo htmlentities($string);

data.csv should be formatted as

Code:

name1,url1
name2,url2
name3,url3
name4,url4
name5,url5

Click to expand...

<?php 
//vars
$filename = "data.csv"; // the file must stay in the same folder where the script is
$folder = dirname(__FILE__);
$data =  $array = $string = NULL;

//function

function array_cartesian() {
    $_ = func_get_args();
    if(count($_) == 0)
        return array(array());
    $a = array_shift($_);
    $c = call_user_func_array(__FUNCTION__, $_);
    $r = array();
    foreach($a as $v)
        foreach($c as $p)
            $r[] = array_merge(array($v), $p);
    return $r;
}

// read the file
$fp = @fopen($folder."/".$filename, "r");
if(empty($fp))
    throw new Exception("file could not be read");
//read from csv
while($data = fgetcsv($fp)){
    $array['url'][] = $data[0];
    $array['anchor'][] = $data[1];
}

$array_new = array_cartesian($array['url'] ,$array['anchor'] );
//print_r($array_new);

foreach($array_new as $new){
    $n0 = trim($new[1]);
    $n1 = trim($new[0]);
    if(!empty($n0) && !empty($n1) )
    $string .= "<a href=\"{$new[1]}\">{$new[0]}</a>  ";
}


// print result
echo htmlentities($string);

LOL-Blaster said:

Can you make it so that blank values are ignored?
The number of urls does not always equal the number of keywords

Click to expand...