skipping characters mysql doesnt like :>

bazn · Post by **bazn** » Mon May 16, 2005 8:39 am

hi i'm trying to skip characters wihcih mysql doesn't like tryed like that :

regsub -all {[\^\[\]\'\"\# ]} $row " " row

but it don't work, it gives me no failure but it doesnt remove the characters

^ \ ' " #

someone can give me a hint?

pz

Post by **Sir_Fz** » Mon May 16, 2005 8:49 am

try:

set row [string map {^ "" \\ "" ' "" \" "" # ""} $row]

Ofloo · Post by **Ofloo** » Mon May 16, 2005 9:46 am

what about a '.' and '`' ...

Post by **Sir_Fz** » Tue May 17, 2005 5:40 am

He asked about stripping "^ \ ' " #". however if ` and . should be skipped too then this will do it:

set row [string map {^ "" \\ "" ' "" \" "" # "" . "" ` ""} $row]

Ofloo · Post by **Ofloo** » Thu May 19, 2005 8:02 pm

just trying to point out that he might wana skip those to

cause he wants to strip out special chars eh ..