Thank you Strongm! That was EXACTLY what I needed... And you guessed it right, the string is the reply from an API call so it includes the " inside the string... Your code was perfect...
Neither one of the two previous suggestions help because if you look closely, you'll see that the string is not comma delimited. It is delimited by the second quote...
HELP!
I have a string that contains the following:
0,"121"33,"AA"1136,"32"30,"32MPBA"29,"470027009917"
I want to separated into individual fields using VB code as follows
Field 0 = "121"
Field 33 = "AA"
Field 1136 =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.