regex in DTS

#1

I use either of these two patterns

1)"d\d\d\d\d\d\d\d\d\d"
2)""d{10}"

to regex a 10 digit number but it never pass the test method (always says
that the input dosen't match) .

Anyone can help?

Thanks

#2

On Wed, 8 Jun 2005 11:12:32 -0700, J-T wrote:

Quote:

I use either of these two patterns

1)"d\d\d\d\d\d\d\d\d\d"
2)""d{10}"

to regex a 10 digit number but it never pass the test method (always says
that the input dosen't match) .

Anyone can help?

Thanks

Try
"\d{10}"

or

"[0-9]{10}"

#3

Thanks ,it worked,stupid dropping of "\":-)
"Ross Presser" <rpresser (AT) NOSPAMgmail (DOT) com.invalid> wrote

Quote:

On Wed, 8 Jun 2005 11:12:32 -0700, J-T wrote:

I use either of these two patterns

1)"d\d\d\d\d\d\d\d\d\d"
2)""d{10}"

to regex a 10 digit number but it never pass the test method (always says
that the input dosen't match) .

Anyone can help?

Thanks

Try
"\d{10}"

or

"[0-9]{10}"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

regex in DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

regex in DTS - 06-08-2005 , 01:12 PM

Re: regex in DTS - 06-08-2005 , 03:06 PM

Re: regex in DTS - 06-09-2005 , 12:30 PM