steverguy
asked on
Extracting Data from a String in Visual Basic 6
I have a string like this:
Amount: ||15 Qty:1 SKU #:B1011 - New Book
I need to pull the B1011 out of it as well as the Price (15) and the QTY.
This is from a shopping cart program and multiple items are seperated by a vbCrLF
So for orders with more than one product, I need to extract all of the SKU#s, QTYs and Prices...
Amount: ||15 Qty:1 SKU #:B1011 - New Book
Amount: ||17.95 Qty:1 SKU #:B1012 - Another Book
Any suggestions? I'm kinda stumped.
Thanks!
Amount: ||15 Qty:1 SKU #:B1011 - New Book
I need to pull the B1011 out of it as well as the Price (15) and the QTY.
This is from a shopping cart program and multiple items are seperated by a vbCrLF
So for orders with more than one product, I need to extract all of the SKU#s, QTYs and Prices...
Amount: ||15 Qty:1 SKU #:B1011 - New Book
Amount: ||17.95 Qty:1 SKU #:B1012 - Another Book
Any suggestions? I'm kinda stumped.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER