Excel/Access VBA parser help

Hi all,

pls need some advice from you how to parse the ouput I get from SAP using function module and VBA.

Here is an example of text I get and I am able to parse using VBA correctly:
0018:000000000081234567,0004:0001,0003:ABC,002:,001:X;0018:000000000087777777,0004:0001,0003:ABC,002:,001:X;0018:000000000087777777,0004:0001,0003:ABC,002:,001:X

Each row is separated by semicolon delimeter
Each column is separated by comma delimeter
Number at the beginning - e.g. 0018 is field length

The problem is that there are some fields that includes semicolon within column which results to incorrectly parsed fields , e.g.
0018:000000000081234567,0004:0001,0003:A;B;C,002:,001:X;0018:000000000087777777,0004:0001,0003:ABC,002:,001:X;0018:000000000087777777,0004:0001,0003:ABC,002:,001:X

Is there any logic I could use to parse this correctly ?
Thank for help
Petr

fixed using regex in my code