Hi,

I'm using Links SQL and have a custom script that has the following lines:

{
$clean_name = $row->{'Full_Name'};
$url = qq~$CFG->{build_root_url}/$clean_name/$CFG->{build_index}~;
}

The variable Full_Name comes from the Links SQL Category table, and my problem are the cases where the Full_Name value has spaces. For example:

Category/Sub Category/Another Sub Category

I somehow need it to take the $clean_name variable and then replace any blank spaces with an underscore character so it would be:

Category/Sub_Category/Another_Sub_Category

Does anyone know of a line I could add to the above code that would accomplish this?

--FrankM

I added the line in red which seemed to work:

{
$clean_name = $row->{'Full_Name'};
$clean_name =~ s/ /_/;
$url = qq~$CFG->{build_root_url}/$clean_name/$CFG->{build_index}~;
}

--FrankM

You may want to add a 'g' in there.. .i.e;


This will make the change 'globally' in the variable (your version would only do the first occurence).

Hope that helps :)

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Thanks Andy, you were right, I did need the 'g' in there.