Generate unique numbers according to specific regex pattern

Hello everyone
I have the following regex pattern

Please Login or Register  to view this content.

You can test on this link
https://regex101.com/r/4et8ee/1

I need to generate valid numbers according to this regex pattern randomly and unique ..
Thanks advanced for help
Regards

I see something in this pattern that could be a bug and I want to make sure it is not.

Please Login or Register  to view this content.

[0-38] means "a digit that is either in the range 0-3, or the digit 8"

If you mean "a number from 0 to 38" then this is wrong.

Can you confirm this part of your expression is correct?

Thanks a lot for reply
Yes it is correct as you explain .. I have updated the regex pattern again

Please Login or Register  to view this content.

at this link
https://regex101.com/r/4et8ee/7

To explain the pattern .. this is national ID that is of length of 14
The first digit should be either 2 or 3
The second and third digit is for year so 00 - 01 - 02 - ......... - 99
The fourth and fifth digits for month so 01 - 02 - 03 - 04 - 05 - 06 - 07 - 08 -09 -10 - 11 - 12
The sixth and seventh for days so 01 - 03 - ............ 31
The eighth and ninth for district and they are not fixed .. they are : 01 to 04 and 11 to 19 and 21 to 28 and 31 to 36 and 88
The last 5 digits are random

I developed an entire solution based on your first pattern and now you have completely changed it. Here is what I did. Hopefully you can modify this for your new pattern. Best of luck.

Thanks a lot for great help
In fact that's great solution but I have to deal with each digit separately .. I imagined that using regex pattern can be read in random way so as to generate those numbers
Generally I will try to modify to suit the new pattern
Thank you very much

I tried to modify but I am lost although the logic seems simple .. Can you help me with the new regex pattern?

Any help in this topic please?

That's great ikboy. Thanks a lot for great and awesome help
I have modified that as it is very clear .. Thanks a lot
Best Regards

Won't that generate dates that include Feb 30th and Feb 31st?

Another way:

Please Login or Register  to view this content.

Thanks a lot for those valuable replies
@shg :: I got a random ID like that
28810130036370

00 is not acceptable .. will I remove 0 from the variable sDist to adjust. .?? and in this case the number 30 will be 29 in this part

Please Login or Register  to view this content.

* last note what If I want to exclude 0 from the last digit .. I mean instead of 0 in the example generated 28810130036370 >> to generate numbers from 1 to 9 and not zero

Thanks a lot for great help

After so much time I could figure it out

Please Login or Register  to view this content.

Thanks a lot for your great and awesome help for all of you

Just one remaining point in this topic ..
As for the first digit 2 or 3 .. should be related to the years .. That's in last code from 1980 to 2020
It is supposed that 2 is related to 1900 to 1999 and 3 is related to 2000 to 2099 .. How can I adjust the UDF to get the desired digit according to the year?

Originally Posted by YasserKhalil

After so much time I could figure it out

Please Login or Register  to view this content.

Since the number encodes year as two digits, extending DOB past the turn of the century only serves to double the likelihood of years 00 to 19.

I am sorry I can't get what you mean ..

In what century was someone born if their date code is 000101?

According to the start and end dates .. 00 means 2000 as 19 means from 1980 to 1999 (this would be 2 as first digit)
and from 2000 to 2020 would be 3 as first digit ... so the start date and end date would determine the proper century ..

Hope it is so clear sir

Please Login or Register  to view this content.

Thanks a lot for your great help
In fact I am lost a little .. The constants that determines start date and end date was perfect for me .. and now in results I found 38410232147697
which is not correct as 1984 related to 2 ...
Can post # 15 be please edited to modify the 2 or 3 but to keep the start and end dates ..?

Sorry ...

Please Login or Register  to view this content.

So what is the start date and end date ...
Is #12/21/1999# right or #12/31/1999# ??
Can start date and end date be constants as in post #15?

The dates of birth vary randomly over the last 100 years.

Originally Posted by shg

The dates of birth vary randomly over the last 100 years.

Is that a problem in dealing with the code? .. Post # 15 is the most suitable for me till now
Just the first digit .. I would use a line at the end of the UDF that determines 2 or 3 according to the yy (year)
Thanks a lot for great help

Please Login or Register  to view this content.

That's perfect and awesome now. Thank you very very very much for great help and thanks a lot for your patience
Best Regards