Delete a specific string of characters delimited by commas

Question

Hi everyone! I am trying to identify if in a row, the sequence of characters "c/v" shows up, and if it does, eliminate all the characters between the previous comma and the following comma. I attach a sample of the input dataset and how I would like to transform it.

Thanks in advance!!

jdunkerley79 · Accepted Answer

I would suggest a formula tool with an expression something like

Regex_replace([Field1], ",[^,]+c/v[^,]+,",",")

Not in front of Alteryx but should be close to what you need