I want to accomplish the following:
- read in a string of characters such as the following into an array
2 a13 3 s4 2 a7b
- go through the array and read each character one at a time
If the character is a number it will be stored into a variable called 'quantity' and next character being a text will be stored into variable called 'itemcode'. Then some code to insert data into a table will be accomplished. I already have this part. After the data insertion is completed, the next character is read. 3 is read and stored into 'quantity'. Next s4 is read from the array and stored into 'itemcode', the data insertion into a table is repeated again. This process will continue until all the characters are read from the array.
How can I accomplish the above?