Simeple Reg Exp Not working

Hello,
Does anyone what RegExp to use for the following.
3-digits followed by "-" or " " then Followed by 6 or 7 digits then followed
by any number of spaces.
111 111111
111-111111
222-123456"" space at the end okay
231 1345678
I just can not figure out the end spaces...
Thank you
SA..
"MSDN" wrote:

> Hello,
> Does anyone what RegExp to use for the following.
> 3-digits followed by "-" or " " then Followed by 6 or 7 digits then follow
ed
> by any number of spaces.
> 111 111111
> 111-111111
> 222-123456"" space at the end okay
> 231 1345678
> I just can not figure out the end spaces...
> Thank you
> SA
>
>
[\d]{3}[-\s]{1}[\d]{6,7}[ ]*
HTH,
Kevin Spencer
Microsoft MVP
Professional Numbskull
Show me your certification without works,
and I'll show my certification
*by* my works.
"MSDN" <sql_agentman@.hotmail.com> wrote in message
news:e7Is63dWGHA.3848@.TK2MSFTNGP05.phx.gbl...
> Hello,
> Does anyone what RegExp to use for the following.
> 3-digits followed by "-" or " " then Followed by 6 or 7 digits then
> followed
> by any number of spaces.
> 111 111111
> 111-111111
> 222-123456"" space at the end okay
> 231 1345678
> I just can not figure out the end spaces...
> Thank you
> SA
>
Kevin,
Thank you it is working know
SA
"Kevin Spencer" <kevin@.DIESPAMMERSDIEtakempis.com> wrote in message
news:%23bv5ASjWGHA.4148@.TK2MSFTNGP03.phx.gbl...
> [\d]{3}[-\s]{1}[\d]{6,7}[ ]*
> --
> HTH,
> Kevin Spencer
> Microsoft MVP
> Professional Numbskull
> Show me your certification without works,
> and I'll show my certification
> *by* my works.
> "MSDN" <sql_agentman@.hotmail.com> wrote in message
> news:e7Is63dWGHA.3848@.TK2MSFTNGP05.phx.gbl...
>
Sorry I did not ask the right question
I ended using
^\d{3}[-| ]?\d{6}\d?[ ]?$
May be I could have used this also
\d{3}[- ]?\d{6}\d?[ ]+
So I want [3 digits ] [Followed by nothing or, - , or space ] [Followed by 6
digits][Followed by zero or one digit][Followed by zero or many spaces]
Again Thank you for your help
SA
"Kevin Spencer" <kevin@.DIESPAMMERSDIEtakempis.com> wrote in message
news:%23bv5ASjWGHA.4148@.TK2MSFTNGP03.phx.gbl...
> [\d]{3}[-\s]{1}[\d]{6,7}[ ]*
> --
> HTH,
> Kevin Spencer
> Microsoft MVP
> Professional Numbskull
> Show me your certification without works,
> and I'll show my certification
> *by* my works.
> "MSDN" <sql_agentman@.hotmail.com> wrote in message
> news:e7Is63dWGHA.3848@.TK2MSFTNGP05.phx.gbl...
>
So, you're all set then?
HTH,
Kevin Spencer
Microsoft MVP
Professional Numbskull
Show me your certification without works,
and I'll show my certification
*by* my works.
"MSDN" <sql_agentman@.hotmail.com> wrote in message
news:utRxFn0WGHA.1200@.TK2MSFTNGP03.phx.gbl...
> Sorry I did not ask the right question
> I ended using
> ^\d{3}[-| ]?\d{6}\d?[ ]?$
> May be I could have used this also
> \d{3}[- ]?\d{6}\d?[ ]+
> So I want [3 digits ] [Followed by nothing or, - , or space ] [Followed by
> 6 digits][Followed by zero or one digit][Followed by zero or many spaces]
> Again Thank you for your help
> SA
>
> "Kevin Spencer" <kevin@.DIESPAMMERSDIEtakempis.com> wrote in message
> news:%23bv5ASjWGHA.4148@.TK2MSFTNGP03.phx.gbl...
>
Kevin,
Yes and thank you,
SA
"Kevin Spencer" <kevin@.DIESPAMMERSDIEtakempis.com> wrote in message
news:OZLwhC2WGHA.3660@.TK2MSFTNGP04.phx.gbl...
> So, you're all set then?
> --
> HTH,
> Kevin Spencer
> Microsoft MVP
> Professional Numbskull
> Show me your certification without works,
> and I'll show my certification
> *by* my works.
> "MSDN" <sql_agentman@.hotmail.com> wrote in message
> news:utRxFn0WGHA.1200@.TK2MSFTNGP03.phx.gbl...
>