[ic] filter existing data

DB DB at M-and-D.com
Mon Feb 5 18:53:21 EST 2007


I have a gift_note column in my transactions table. I've noticed that if
customers hit the return key while adding data to this field from the
checkout form, it screws things up when I export this data as a csv
file. I've since created a filter for this to strip these "returns":

CodeDef no_crlf Filter
CodeDef no_crlf Routine <<EOR
 sub {
my $val = shift;
$val =~ s/[\r\n]+/ /g;
return $val;
}
EOR

but how can I apply this filter to the existing mysql data which was
submitted before I had this filter in place?

DB


More information about the interchange-users mailing list