I have a CSV file that is pipe delimited. I can only have one row per id. The entire column is not duplicated since the results are from an outer join but I can't have more than one result per ID so I just want to take the first result and delete the all others.
I looked at the Duplicate Master Add on, but since the rows aren't always exact I can't use it.
I am attaching a sample of data. So the basic idea would be to check the value before the first delimiter and delete any subsequent rows with that same id.