http://qs1969.pair.com?node_id=231338

Willman023 has asked for the wisdom of the Perl Monks concerning the following question:

I just wrote a short script to parse out &lt;/&gt; and replace with </> in a DB(code below). But for some reason its not matching every symbol. For example, on the 12th line of a description I have:

icon or choose the Results-&gt;View Plotfiles you

and for another I have:

<br>&lt;/pre&gt;<br>&lt;img src=http://blah.microsoft.com/analog_sc/bp +/_lessons_learned/2788_1.jpg&gt;<br>&lt;br&gt;<br>&lt;img

How can I match any &lt; and &gt;?
Thanks!

#!/opt/perl/bin/perl -w use Win32::ODBC; use strict; # MAKE CONNECTION AND QUERY ACCESS DATABASE my $connstring = "EPI_DB"; my $db = new Win32::ODBC($connstring) or die $!; $db->Sql("SELECT entry_id, description FROM entry"); my $description; my $entry_id; while ($db->FetchRow()) { $description= $db->Data('description'); $entry_id = $db->Data('entry_id'); tagremover($description); my $db2 = new Win32::ODBC($connstring) or die $!; $db2->Sql("UPDATE entry SET description='$description' WHERE entry +_id=$entry_id"); } print "Cleaning Complete\n"; $db->Close(); # FUNCTION TO CLEAN TAGS FROM DATABASE sub tagremover { $_[0] =~ s/&lt;/</g; # REPLACES ALL HTML < SYMBOLS IN DB $_[0] =~ s/&gt;/>/g; # REPLACES ALL HTML > SYMBOLS IN DB }
bW