Spotless is a web service to filter incoming feeds according to business rules as they come into your data platforms. It's easy to incorporate into your applications to ensure that you always have clean data to work from. There are different types of rules to validate whether data is correct and some various options for how invalid data is handled:
When you execute a filter, Spotless creates a job which then provides a report on the cleanliness of the file and actions that have been taken.
We have several demonstration videos, including the one below that shows how you can use Spotless. In essence, you should start by uploading a CSV file here, customise the rules to suit your needs, and then hit “run.” There is an example file you can download here for your testing.