Generate Random and fill with comma every 2 digits

jaguarconsultoriadig · 2020-10-21T17:25:28.303Z

Hi

Please, I need to generate a random 12-digit number and have a comma between every 2 digits generated.

Example:
Random = 102030405060

I need the Random to look like this: 10,20,30,40,50,60

How to do Bubble?

Thanks

mikeloc · 2020-10-21T18:07:43.188Z

Hi there, @jaguarconsultoriadig… here are two ways to do it that produce the result you have described.

Admittedly, this first way might be a bit hacky, but I went this route first because I don’t know much about regex (which I assume is the “correct” way to go about it). So, I have an input, and I am using the Calculate formula >> Generate random string option to set its initial content…

genrand704×259 12.2 KB

You can use that option to generate a random string of 2 numbers and then string 6 of those together with commas (I am only showing 2 in the following screenshot, but you get the point)…

twochars705×343 15.9 KB

The second way I went about it was to actually try to use regex, and after a bit of searching, generating a random string of 12 numbers and then using this find and replace seems to work…

regex701×372 16.1 KB

So, if it was me, I would probably just use the first way and be done with it, but since I was able to get the regex option to work, I figured I would drop it out here, too.

Hope this helps.

Best…
Mike

jaguarconsultoriadig · 2020-10-22T02:20:51.362Z

Thanks very much !!!

system · 2020-12-30T17:25:28.949Z

This topic was automatically closed after 70 days. New replies are no longer allowed.