Password data validation (regex code?)

[jaryszek]

Hi,

i have to implement DV for passoword like here:

https://docs.microsoft.com/en-us/azu...-creating-a-vm

from website:

Passwords must be 6 - 72 characters in length and meet 3 out of the following 4 complexity requirements:

Have lower characters
Have upper characters
Have a digit
Have a special character (Regex match [\W_])

i have to add function in VBA and add to named range and this named range add to dv custom field.

How to write the function?
Use regex class?

Please help,
it is complex thing.

Best,
Jacek

[jaryszek]

Hi,

i created a code but i need help with this to combine separated regexes patterns :

Please Login or Register  to view this content.

in this case 3 conditions are met: 2,3 and 4 without first (no Upper case letters here) so whole function is True (if 3 or 4 conditions are met = true, otherwise = false).

How can i do this without counter in one pattern statement? It is possible ?

Best,
Jacek

[jaryszek]

Bump anyone?

Jacek

[jaryszek]

Please help,

Jacek

[Phuocam]

Try this:

Please Login or Register  to view this content.

[jaryszek]

Hi,

what is the difference between my function?

The goal of this topic is to group all regex pattern into one pattern statement.

To have all requirements in one place?

Best,
Jacek

[KOKOSEK]

try:

Please Login or Register  to view this content.

[jaryszek]

hi,

thank you very much.

Can you explain how this is working ?

Best,
Jacek

[KOKOSEK]

(?=.*[a-z]) #Check if there is at least one lowercase in string
(?=.*[A-Z]) #Check if there is at least one uppercase in string.
(?=.*[0-9]) #Check if there is at least one digit in string
(?=.*\W) #Check if there is at least one special character in string.
.*$ #catch full string if all the conditions are met

[jaryszek]

thank you.

.*$ #catch full string if all the conditions are met

I need here not all conditions but only 3 from 4 have to be met.
It is possible to do this?

Jacek

[KOKOSEK]

I am not good enough with regExp. I am not sure is it possible.
IMHO criteria is criteria, if you create criteria it has to be met.

[jaryszek]

Thank you,

criteria are:

Passwords must be 6 - 72 characters in length and meet 3 out of the following 4 complexity requirements:

Have lower characters
Have upper characters
Have a digit
Have a special character (Regex match [\W_])

[KOKOSEK]

I've seen it. I don't know to to implement 3 out of 4 into RegExp pattern.

[jaryszek]

ok thank you,

maybe this is not possible.
Or maybe there is another class.

Jacek

[jaryszek]

It is possible ?

Jacek

[karedog]

If it must be single pattern ( because so many people hate loops ), then :

Please Login or Register  to view this content.

[jaryszek]

o wow,

thank you.
| this means OR?
and this? ^ what does it mean?

So you provided all combinations and use OR hmm interesting!
But maybe loop is better here

Jacek

[karedog]

You are welcome, thanks for the reps.

Yes, | is or, ^ is anchor for beginning of string, $ is anchor for end of string.

Yes, I combine KOKOSEK's pattern using OR operator.

If you are using loop, then actually you have provided the solution for yourself in your OP statement, aren't you ?

[jaryszek]

Yes,

exactly but i thought that there is only some magic short code to do this

Jacek

[karedog]

AFAIK, no short pattern for this.

To match independent position of pattern (location of occurrence is not important, can be shuffled and combined), the regex look ahead method (?=) must be used.
But look ahead doesn't capture anything, it is just used as another "prerequirements" to the pattern, so we cannot examine this look ahead result (there is no result from the look ahead pattern itself).
So, as the consequences, you have to include all the combinations, in single pattern.

Regards

[jaryszek]

Thank you once Again,

Jacek