Hi all,
I am trying to use the replace() function in MySQL 4.1.13a to find and
remove tab characters. I'm not sure how to signify the tab char, however.
I've tried, \t to no avail:
update products_description set products_description =
replace(`products_description`,\t, ) where products_id
[snip]
Does anyone have any suggestions? The mysql server [and client] are
running under Linux. The products_description field is a 'text' type. If
there's further info you need, please let me know.
[/snip]
Are you using REPLACE(column_name, '\t', ' ') ?
--
MySQL General Mailing List
For list
On Wed, 1 Mar 2006 [EMAIL PROTECTED] wrote:
} [snip]
} Does anyone have any suggestions? The mysql server [and client] are
} running under Linux. The products_description field is a 'text' type. If
}
} there's further info you need, please let me know.
} [/snip]
}
} Are you using
On Wed, 1 Mar 2006, Vince LaMonica wrote:
} update products_description set products_description =
} replace(`products_description`,'\t',' ') where products_id = 37;
[snip]
I should have also stated that in the above example, both the table name
and the column name are the same - that's not a
@lists.mysql.com
Subject: using replace() to remove tab chars
Hi all,
I am trying to use the replace() function in MySQL 4.1.13a to find and
remove tab characters. I'm not sure how to signify the tab char,
however.
I've tried, \t to no avail:
update products_description set products_description
On Wed, 1 Mar 2006, Price, Randall wrote:
} Try the following:
}
} REPLACE(products_description, CHAR(9), )
Thanks, Randall, that did it. And I feel quite stupid, as well, because I
re-checked my two test entries [33 and 37] and both had had their tabs
removed at some point. So it turns out