This tool is a simple flat file validator.
You have to enter the file structure as JSON and the file content. Each record must be on a separate line. You will receive the validation result as JSON and for each record or each record type (depending on your settings) a table with the records splitted into the fields. Fields with errors are marked in red. You can find the error in the tooltip of the field.
The following things can be checked:
- if the record is to long
- if obligatory fields are filled
- if fields contain only allowed values
- if fields match with a regex
Please be aware that the fields are checked without right trim. This means "ABC" differs from "ABC ".
You can find the JSON file format schema here or including example data in the tool (just press the button "Fill with demo data"). You should use an external JSON schema validator. There is only an alert if the JSON could not be parsed. There is also a helper in the tool to generate the JSON from tab delimited data like in this Excel sheet.
The tool needs no server. You can download the repository, unzip it and just open the index.html in the docs folder with a browser.
The own source code of the Flat File Validator is subject to the MIT license. But the tool has dependencies to frameworks that subjects also to other licenses. It is created with TypesScript (Apache-2.0 license). It uses UI5 Web Components (Apache-2.0 license) and the Vite Framework(MIT license).
The Vite Framework converts the TypeScript source code of the Flat File Validator together with the dependent source code into a single JavaScript file and minifies it. So it modifies also the dependent source code of the used frameworks. The used frameworks have additional dependencies. GitHub automatically lists the detected dependencies of this repository. You can find them here. Please see also the documentation of the used frameworks for further information.