[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