I get some data which I manipulate in to a string variable. The data contains up to 20 numbers (in reality these are monetary values) separated by a comma, which can change each time I get a new item from the queue. For example, the string could be 678, 635, 632, 785 then for the next queue item it could be 6746, 57574
Each time I work an item from the queue, I need to split these values (by using the comma) and then put them in to individual variables named accordingly as ‘monetary value 1’ monetary value 2’ and so on. I also need to count how many monetary values I have worked with, as I will need this value later on in the process.
Please can I ask you all for the best way to achieve this?
Thanks for the help,