preg_replace help

[DuamuteF]

Hello,
I was wondering if someone could help me with this problem.
I am having with preg_replace.
Here is my code.

$pbefore = "something.txt#something.txt#";

echo "<br>\n";
echo $pbefore;

$search = "(.txt#)";
$match = preg_replace($search, "", $pbefore, 1);
	echo "<br>\n";
	echo $match;

I am trying to change something.txt#something.txt# into
something.txt
The reason for this is i have an sql database that was converted from a access database that had hyperlinks to doc, pdf, and txt files. In the process of converting it, changed the hyperlinks to .#.#. There are 3000+ records so it would take forever by hand.
Thanks in advance for any help.
--DuamuteF--

[stolzyboy]

<?
$string = "something.txt#something.txt#";
$pos = strpos($string, "#"); //finds position of first instance of the #
$newstring = substr_replace($string, "", $pos); replaces everything after and including the # with nothing
echo $newstring;
?>

[DuamuteF]

Thanks for the help.
--DuamuteF--

[stolzyboy]

np, is that gonna work for ya

[DuamuteF]

Yea, unless you know a way that would change.
something.txt#something2.txt#
to something2.txt.

[stolzyboy]

<?
$string = "something.txt#something2.txt#";
$pos = strpos($string, "#");
$newstring = substr_replace($string, "", 0, $pos);
$newerstring = str_replace("#", "", $newstring);
echo $newerstring;
?>

[DuamuteF]

That worked perfectly.
Thank you very much.
--DuamuteF--