Delete a specific string of characters delimited by commas

[tutankamon]

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 solution]

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

[tutankamon]

Thank you very much! It works perfectly!!