Shell Programming and Scripting

Lets say I have file.txt:
(Product:Price:QuantityAvailable) (: as delimiter)
Chocolate:5:5
Banana:33:3

I am doing a edit/update function.
I want to change the Quantity Available, so I tried using the SED command to replace 5, but my Price which is also 5 is changed instead.
(for the Banana case, if I were to replace 3 with 5, my price will be 53 because it replaced the 3 which comes first)
Is there a way to only replace data within the Delimiter?
Or rather, how should I go about solving this?

Thanks in advance!

Code:

$ cat file1
(Product:Price:QuantityAvailable) (: as delimiter)
Chocolate:5:5
Banana:33:3

$ sed "/^Chocolate/ s/[^:]*$/14/" file1
(Product:Price:QuantityAvailable) (: as delimiter)
Chocolate:5:14
Banana:33:3

Other languages, like awl handle "delimeters" better than sed.

Depending on how exactly you want to edit:
If you want to change all line having "Chocolate:5:5" to "Chocolate:5:10"

Code:

sed 's/Chocolate:5:5/Chocolate:5:10/'

OR change all lines "Banana:33:3" to "Banana:33:5"

Code:

sed 's/Banana:33:3/Banana:33:5/'

OR change line Banna pricers to 5 (whatever be the current price)

Code:

sed 's/Banana:\(.*\):\(.*\)/Banana:\1:5/'

Thanks guys,
another question here. (Sorry, I just started learning bash programming last week)

but what if my data was like this:
Chocolate:12:12:12:12:12:12:12

say I want to replace the 4th 12 to 5 without changing the rest of the 12 infront of it? If I were to code it the way using start with Chocolate:12:12:12: and start replacing, wouldn't it be problematic if my files were to have alot data?
I'm not restricted to using SED, but restricted to using BASH.
Are there any suggestions?

Thanks alot.

Well, I never saw that question coming

sed starts getting ugly when you try to do this stuff.

Code:

$ awk -F: '/^Chocolate/ {$4=5}1' OFS=: file1
Chocolate:12:12:5:12:12:12:12

Really thanks and appreciate your fast reply!
I'll give the code a try later. (currently learning to do other functions)

Thanks again!

Not that ugly

Code:

sed '/^Chocolate/s/[^:]*/5/5' file

(4th 12 is the fifth field, right?)