Link to home
Start Free TrialLog in
Avatar of steverguy
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!


ASKER CERTIFIED SOLUTION
Avatar of sirbounty
sirbounty
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of steverguy
steverguy

ASKER

Thanks for the quick response.  I tried something similar but couldn't get it to work. I appreciate it.