Ask HN: Massaging many client CSV/textfile to correct columns/format etc.?

We have hundreds of files arriving every month and each client’s layout looks a bit different.

For a single client, each file they send will be the same.

But each client has their own layout.

Is there a good service around that I can setup conversion templates?

Would be great if we can setup a template for each client and the file gets run through the template and arrives happily in our standardised layout.

I haven’t managed to find one but no doubt I’m just using the wrong search terms

Source link