Fixed length for random number generation

Help
1

Hihi

I need to create a 4 digit random number, however when I used new random().Next(0000,9999) this also generated results such as 123/ 25. I need it to start with 0123 or 0025 - to get 4 digits. Any idea how to do this? I tried formatvalue but that does not seem right.

Thank you!

2

Have another variable make it constant with what number you need then Concatenate it with actual generated

var Const = 0123

and new random().Next(00,99)

Thanks,
Prankur

3

Hi @donutlearns,

Your question seems to be interesting, i have tried this and got the result.

The one thing i did was i have generated random number from 0000-9999 and took the resulted value concatenated with “0000” to the left.

and finally i used substring and took last 4 digit number.

I think this is what you were looking at.

Summerized:

Random number-23
concatenate string-0000

Result=000023

Final result=0023

Thank You

Regards,
Kanthesh

P.S- If you require a solution workbook please ping me.

4

Hello,

I have attached a working solution.

.Random.xaml (6.0 KB)

1 Like
5

Thanks @kantheshm

I did not think of it this way! Nice.

6

Thanks @Anusha_Makam

This is exactly right! Awesome!

7

I think @Anusha_Makam has tried my logic and got right,
Appreciate it.

Hi @donutlearns,

Mark your question as answered with a solution marked,so that others can find solution and try that out.

Regards,
Kanthesh

8

hi
i am using random function {"new random().next(1,100) " } ,but it’s generated duplicate numbers ? please help me

9

my requirement is " excel file column A is their 100 values " so robot take the random value from column A ?

10

Hi,

Padleft should be able to help.

new random().Next(0,9999).ToString.padleft(4,CChar(“0”))

Best Regards,
ZaiHao

1 Like