Underscore to Space and Vice Versa

Anon

Hey there...I'm having a little problem.
What I need to do is take the underscores out of a file name and make then into spaces so that when displayed in a web page or drop down list the underscores are not visible.

The data in the database has spaces but the file names do not.

So when I extract the data and use it in a likn to the file I need to get rid of the spaces.

I have two pieces of code here.

One that will change the spaces to underscore (javascript):
<% FNamecheck=FName
Dim answer
answer = " "

FName = ""
FNamelength = len(FNamecheck)

for x = 1 to FNamelength
temp = mid(FNamecheck, x, 1)
temporary = StrComp(temp,answer)

if temporary <> 0 then
FName = FName&temp
else
FName = Fname & "_"
end if

next %>

...and another that will take the data from the database and makes an html link from it(PHP):

$result = mysql_query("SELECT DISTINCT fieldname from tablename", $db);
print '<select name=somename>';
while ($myrow=mysql_fetch_array($result)) {
printf('<option value="%s.htm">%s', $myrow["SONG_TITLE"], $myrow["SONG_TITLE"]);
}
print '</select>;

I'm wodering how can I combine the two to accomplish what I need to do.

Any help will be VERY much appreciated.
Jaymz

Anon

To change all the "" with " " use $filename = preg_replace("//", " ", $filename);

$result = mysql_query("SELECT DISTINCT fieldname from tablename", $db);
print '<select name=somename>';
while ($myrow=mysql_fetch_array($result)) {
$song = preg_replace("/_/"," ", $myrow["SONG_TITLE"]);
printf('<option value="%s.htm">%s', $song, $song);
}
print '</select>;

Anon

Hi,

You may use str_replace

$newstr=str_replace(""," ",$str);
to replace '' with ' '

Hth

JBL

Anon

Thanks so much.
You have been a really big help to me.

Cheers!
Jaymz

Anon

Baaah!

This is the slowest possible method to use. Since you're only worried about one character, there is a function, called 'strtr()' that will do exactly what you need without the overhead of regular expressions.

http://www.php.net/manual/function.strtr.php

Try:
$no_underscores = strtr( $mytext, '_', ' ' );

It also works with more than one character, but the replacements are only mapped 1-1. A quick cheezy example: to replace all vowels with a number, except the letter 'Y', which you want to be replaced with a question mark:

$results = strtr( 'Hello my world!', 'aeiouy', '12345?' );

$results == 'H2ll4 m? w4rld!';

It's of limited usefulness, but sometimes it's just perfect, and your problem is one of those times.

--Robert