Forum Discussion
Solved
How to Create Random, Unique, Alphanumeric Data in a Field
I need to move some data from one system to another. The second system requires a Unique ID field that is 6 digits long, alphanumeric. -my current data comes from two sources and does not have a...
HI SharonHMA,
You can try to use below formula to create guid column, the max count of characters combo is 308,915,776 (26^6).
GUID = UPPER(UNICHAR(RANDBETWEEN(97,122)))&UNICHAR(RANDBETWEEN(97,122))&UNICHAR(RANDBETWEEN(97,122))&UNICHAR(RANDBETWEEN(97,122))&UNICHAR(RANDBETWEEN(97,122))&UNICHAR(RANDBETWEEN(97,122))
Regards,
Xiaoxin Sheng
You could try:
- creating an index column numbering each row 1, 2, 3 etc
- creating further columns that effectively convert that number to base 26 (divide the number by various powers of 26, round it down, if the result is more than 26, take off the relevant multiple of 26 so it isn't)
- that'd give you six numbers between 0-25 that you can then switch to letters and concatenate them together