Data Prepper

Data Prepper is a tool for preparing tabular data to be used in another application, such as a database or a website.

With it, you can extract columns from files, rearrange the columns, reformat the data, replace the data, and merge multiple files in to one output file. Data Prepper can merge multiple files into one results file, trim whitespace from all columns or selected columns, and read and reformat dates, times, and numbers.