How to find strings with a certain substring and replace them with another substring?

Question

linux

It is necessary to iterate over the csv file and (for example) if it contains a line containing ' Accustic Arts' , then replace xxxx located in this line with yyyy

'xxxx';'41680';'Tart_200005338';'Accustic Arts POWER-ES MK2 silver';'Accustic Arts';'20';'300960.00';'N'

How to write a one line command for such a simple replacement?

Answer 1

sed -i '/Accustic\sArts/s/xxxx/yyyy/' file.csv

Answer 2

Something like

sed -ri 's/(.*)xxxx(.*Accustic Arts.*)/\1yyyy\2/' file.csv