Script to convert 10,000 links?

Gary_Kambic

Hello,

I'm in the process of changing my menu system and I need to convert the URLs to the new format.

I was wondering if anyone would happen to know if their is a script available and if not, could you help me with the code to convert them?

I have provided a sample of the URLs below and the format they need to be converted to. Input into the script would be the following text placed in a variable, then parsed and converted.

I would appreciate any help on this one.

Thanks,

Gary

FROM:

<option value="http://www.amana.com">Amana</option>
<option value="http://www.ariston.com">Ariston</option>

TO:

"text:Amana" "4" "" "LINK:[url]http://www.amana.com,_blank[/url]" "Amana"

"text:Ariston" "4" "" "LINK:[url]http://www.ariston.com,_blank[/url]" "Ariston"

drew010

here is a little program to do it,
I tested it out with what you showed and I get the same as what you wanted it to look like.

set $oldFile to what the name of the current like file is, and then make $outFile the one where you want the new links to end up.

<?php

$oldFile = "links.txt";
$outFile = "new.txt";

$data = file($oldFile);

$fp = fopen($outFile, "w+");

foreach($data as $one) {
	preg_match("/<option value=\"(.*)\">(.*)<\/option>/i", $one, $matches);

fwrite($fp, "\"text:{$matches[2]}\" \"4\" \"\" \"LINK:{$matches[1]},_blank\" \"{$matches[2]}\"\r\n");
}

fclose($fp);

?>

freebie

Are your links hard coded into pages, or are they in a database. If in a database, use PHP like in previous example, else if they are hardcoded use dreamweavers "Extended find and Replace" and check the "use Regular Expressions" checkbox. I'm not going to write the regular expression right now, but it wouldn't be difficult.

Gary_Kambic

Hello Drew,

Thanks for the code. I'm in the processing of working on it right now.

I setup a web page to input the data and then send it to the processing page.

Right now I copy and paste the old text in a submit text window:

<option value="http://www.amana.com">Amana</option>
<option value="http://www.ariston.com">Ariston</option>

and when it gets to the processing page it looks like:

Amana
Ariston

It is not echoing the statements correctly. I'm I missing some statement that checks for escape characters?

Below is the code I am using:

input ----

output ----

<?php
$code_input = nl2br($code_input);

echo $code_input;

$todayis = date("l, F j, Y, g:i A");
$month = date("m");
$day = date("d");
$year = date("Y");
$a = floor((14-$month)/12);
$y = floor($year+4800-$a);
$m = floor($month+12*$a-3);

/------------------------- Begin Menu Conversion Process ------------------------/
$oldFile = $code_input;
$outFile = "new.txt";

$data = file($oldFile);

$fp = fopen($outFile, "w+");

foreach($data as $one) {
preg_match("/<option value=\"(.)\">(.)</option>/i", $one, $matches);

fwrite($fp, "\"text:{$matches[2]}\" \"4\" \"\" \"LINK:{$matches[1]},_blank\" \"{$matches[2]}\"\r\n");

}

fclose($fp);

I would like the output file as $outFile, and I will just display this on a webpage (ie.,

Thanks very much,

Gary