This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to clean some data that's been a bit poorly formatted. The data is tab separated, but formatted in such a way that sometimes there is an extra tab, which then results in a warning of either "Too many fields in record," or "Not enough fields in record," if a value is pushed to a new row.
Ideally, I'd like to figure out a systematic way to find these extra tabs, and delete them; returning the rows to their proper format. As this seems like it would be rather difficult, I'd settle for the simpler solution of simply deleting these problematic rows, or of collecting the warning/error messages and then using them to filter the rows out.
I've been looking through the forums here and haven't had much luck in finding a solution to something that would seem to be rather simple. If someone could relieve me of my current ineffectual disposition by either helping me with the simpler solution of deleting the problematic rows or collecting the errors/warnings, or the more ideal solution of removing these extra tabs systematically, I would be most appreciative.