I have an application that has different inputs. Most of them are txt files or CSV/Excel Files. They contain the same type of data, though they are formatted in different ways (order of columns different, sometimes they are separated with spaces, or tabs).
How can I achieve a sort of automation that, based on the knowledge that I know the type of output data, parses the input data "normalizing" them into the same format?
What technologies do I need to look for?