regular expression question 1

[fgeorge]

i need a regular expression that will validate the following:
1)must contain 15 digits..
2)all numbers must begin with 234803
3)
must not be;
234803200
234803201
234803202
234803209

thx

 

[PHV]

Try something like this:

varOK=False
If  Len(var)=15 And IsNumeric(var) _
And Left(var,6)="234803" Then
  tst=Mid(var,7,3)
  If  tst<>&quot;200&quot; And tst<>&quot;201&quot;  _
  And tst<>&quot;202&quot; And tst<>&quot;209&quot;  Then
    varOK=True
  End If
End If

You can encapsulate this snippet with a boolean function.

Hope This Help
PH.

 

[onpnt]

so in actuality you want a string (but numeric) validated as
"234803" plus a max/min of 9 more numerics? ignoring the nine digit examples posted!

first step is to write the function obviously


Function RegExp(str)
Dim regEx, retVal
Set regEx = New RegExp
regEx.Pattern =
regEx.IgnoreCase = False
retVal = regEx.Test(str)
If retVal Then
RegExp = "The value tested ok"
Else
RegExp = "The value was not valid"
End If
End Function

alert(RegExp("234803123456789&quot)

this is the most common structure to a test method in vbscript on regular expressions.
the pattern is failry simple
the unchanged string
"(234803)"
Then you need 9 more numeriuc values and only 9
\d = any numeric value (or you can do [0-9]
then the { } for the count
{9}
don't forget the + the ^ marking the start of the string and the $ to mark the end
and there you have it
"^(234803)+[\d]{9}$"

_____________________________________________________________________
_{You can accomplish anything in life, provided that you do not mind who gets credit.
Harry S. Truman}

http://www.onpntwebdesigns.com

 

[onpnt]

erm. forgot to jsut add the InStr
you could nest them but to keep it clean
InStr(str,"234803201&quot
eg
Function RegExp(str)
Dim regEx, retVal
If Instr(str,"234803200&quot or InStr(str,"234803201&quot > 0 Then
alert("error&quot

Else

Set regEx = New RegExp
regEx.Pattern = "^(234803)+[\d]{9}$"
regEx.IgnoreCase = False
retVal = regEx.Test(str)
If retVal Then
RegExp = "The value tested ok"
Else
RegExp = "The value was not valid"
End If
End If
End Function

alert(RegExp("s234803201456789&quot)

_____________________________________________________________________
_{You can accomplish anything in life, provided that you do not mind who gets credit.
Harry S. Truman}

http://www.onpntwebdesigns.com

 

[fgeorge]

the next 3 digits after 234803 must not be 200,201,203 or 209..

 

[fgeorge]

hello onpnt!!

if i use ^(234803)+[\d]{9}$ the number "54" is allowed through..
this should not be so...
the number 2348032003456 is allowed through too...
any one help?

 

[onpnt]

the number 54 was not allowed here. have you cahnged the function at all? can you post the function?

It is impossible for 54 really to go through. the ^ indicates that being a false test as ^23 must be the starting numeric value

also, this line
If Instr(str,"234803200&quot or InStr(str,"234803201&quot > 0 Then
is where you're 200,201 ect.. is not allowed

unless you want to do multi tests that would be how I would procede

_____________________________________________________________________
_{You can accomplish anything in life, provided that you do not mind who gets credit.
Harry S. Truman}

http://www.onpntwebdesigns.com

 

[strongm]

Use this as the pattern in onpnt's code, and then you can drop the instr component completely:

"^23480320[3-8][\d]{6}$"

 

[onpnt]

the simplification of that is genius in itself. we so often think to large and forget the small bytes that we can use in our favor.

* for the tip on that strongm

_____________________________________________________________________
_{You can accomplish anything in life, provided that you do not mind who gets credit.
Harry S. Truman}

http://www.onpntwebdesigns.com

 

[PHV]

I don't know what is the opinion of fgeorge but the

 "^23480320[3-8][\d]{6}$"

don't allow all the permissible values. The 20 in position 7-8 is not mandatory IMHO.

 

[onpnt]

ha, but the building foundation is there. my greatest fear to bring professionals here at TT is a copde post and nothing learning from your visits and problem solving instances with the ablility to work with other professionals as ourselves.

in strongm bringing to the white board the fact not to validate the long value of a 200, 201 scenario and taking it down a step to saying, "why not simply the digit?"

say +[\d]{3}| not (20)[\d] Then giving the factor that the long way is not always the better but the one factor that may be unique and singled out can be the pointing tool.

well, that enough chibberish

_____________________________________________________________________
_{You can accomplish anything in life, provided that you do not mind who gets credit.
Harry S. Truman}

http://www.onpntwebdesigns.com

 

[onpnt]

jsut to further everything also. with strongm's suggestion and then PHV's points. Further back to my stating the multi tests you could very easy switch the logic in the RegEx function with two test's while changing the objects pattern.
basically from strongm you can use
regEx.Pattern = "^(234803)+(20)+[\d]{1,}$"
to .test and if true is returned then you have the values not wnated. although if that was not true and returned false you can use the other pattern by setting the pattern to the
regEx.Pattern = "^(234803)+[\d]{9}$"
along the same of testing true to false giving the appropriate response from the function.

_____________________________________________________________________
_{You can accomplish anything in life, provided that you do not mind who gets credit.
Harry S. Truman}

http://www.onpntwebdesigns.com

 

[strongm]

Whoops...missed that requirement when reading the question. Try:

"^234803(20[3-8]|[^2][^0]\d)\d{6}$"