Posted by NickName on 09/18/05 23:18

Hi,

This is not SQL Server database problem, however, net search has failed
to generate a solution to the problem, I'm trying my luck at this NG
now.

Problem, remove the special character, [ from text.
e.g. text =
"this is [1] and [stuff] and some [2] and hat [3] and dog"

Desired result =
"this is 1 and [stuff] and some 2 and hat 3 and dog"

I know [[:digit:]] would find all the instances of digits inside
brackets such as [1], [2], [3]. However, I don't know how to get rid
of the special characters of [ and ].

Any regular expression expert out there?

Thanks.

Don

• Next in forum: Re: NOLOCK and READPAST on same table?
• Prev in forum: Re: IDENT_CURRENT and empty table
• Thread view: Reg Exp for digits

[Reply to this message]