egghelp/eggheads community

skipping characters mysql doesnt like :>

2005-05-19T20:02:52-04:00

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

cause he wants to strip out special chars eh ..

Statistics: Posted by Ofloo — Thu May 19, 2005 8:02 pm

2005-05-17T05:40:38-04:00

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

Code:

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

Statistics: Posted by Sir_Fz — Tue May 17, 2005 5:40 am

2005-05-16T09:46:01-04:00

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

Statistics: Posted by Ofloo — Mon May 16, 2005 9:46 am

2005-05-16T08:49:47-04:00

try:

Code:

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

Statistics: Posted by Sir_Fz — Mon May 16, 2005 8:49 am

2005-05-16T08:39:32-04:00

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

Code:

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

Statistics: Posted by bazn — Mon May 16, 2005 8:39 am