Hi Everyone -
I'm trying to extract the quantity number from the text AND if there isn't a quantity for it to return "1".
My end goal is to divide this number by a price to get the individual unit price.
As you can see sometimes it's at the beginning or end and may be followed by "pack or "/case"
I found some equations that can solve part of what I'm doing but can't figure out how to combine them correctly
I may be looking for the impossible. Any help or advice is appreciated.
Thanks very much.
I'm trying to extract the quantity number from the text AND if there isn't a quantity for it to return "1".
My end goal is to divide this number by a price to get the individual unit price.
As you can see sometimes it's at the beginning or end and may be followed by "pack or "/case"
I found some equations that can solve part of what I'm doing but can't figure out how to combine them correctly
I may be looking for the impossible. Any help or advice is appreciated.
Thanks very much.
Price | Description | Unit | Price/unit |
$100 | 10 pack, GAC post-carbon cartridge 1/4" JG black housing | 10 | $10 |
$40 | Storage Tank / 9 Gallon | 1 | $40 |
$600 | GAC Carbon Post Filter Cartridge, 3/8 JG, 50 PK | 50 | $12 |
$350 | RO Module, 30 gpd GE TFM-36A, 25/Case | 25 | $14 |