Headers

CsvPath Validation Language examples for managing CSV/Excel file headers

Try these examples yourself. They are built into FlightPath Data. You can download FlightPath Data free from Microsoft or Apple or GithubGithub

Using headers

Headers are the names of values in a CSV or Excel file. In a delimited file, any given line may not have values for the headers. And headers can change or be found at any point in a delimited file.

CsvPath Framework has many functions to help you work with headers. Most of the functions are oriented towards creating validation rules. Some of the header functions are quite unique. For example, in CsvPath Framework, you can reset the headers to the values of the current line at any time.

These examples will help you start validating and upgrading your CSV and Excel files using the header functions to create rules.

• Collect matching lines

• Replace values

• Insert and append

• No blanks

• Reset headers

• Name check

• Position check

• More header checks

• End