Make any values that contain a comma (',') empty

I want to update any values in a column that include a comma to be empty values,

so a value of "ABC,XYZ" becomes empty, but a value of "ABC" remains "ABC".

I've spent some time on this and have a workaround, but there must be a way of creating a function in the Modify Columns action?

I also need a way to update any values with more than one comma to be "LABEL ERROR" so I can flag these for resolution in the source data as there should never be more than two labels.

Try the rule action on this column:

... with this input:

image

labelerror.morph (2.6 KB)

2 Likes