excel - Change the value of the key, then delete the key on comma delimited CSV using regex

Question

I got this pattern:

...,432,3333333,607,5500,617,5000,... ...,66,88,432,22625,607,45330,617,5000,... ...,432,3600000,607,87,617,5000,...

From a multi columned csv file delimited by comma, The data should be, the first column should be the key, the second column should be the value, so what I was asked to do is to set all specific keys to zero, and delete the key

I need to delete all "607" keys to the csv hence, the above should result to:

...,432,3333333,0,0,617,5000,... ...,66,88,432,22625,0,0,617,5000,... ...,432,3600000,0,0,617,5000,...

Hope this can be done in regex, because this can't be done anymore in excel.

Thanks!

Answer 1

Regex:

,607,[^,]*

Replacement string:

,0,0

DEMO