Transpose a Comma Separated Field

[haymarketpaul]

I have a field with comma separated numbers that I just need to turn into a column of single numbers - How to transpose in the script?

eg  Field of UserIDs

12345,23456

34567,45678,56789,67890,54321

82736

65432,11223,22334

Would become field with the following:-

12345

23456

34567

45678

56789

67890

54321

82736

65432

11223

22334

[haymarketpaul · Accepted solution]

Got it...

SubField(UserID,',')