Validation

Let's assume that we have a large csv with column headings each of which has a specific request and we need to check the data, you can do this by setting up such a formatted csv file:

• The name of the garment (must be the same as the fields defined in the first row of the data file)
• choose L, R, S, SI, U, UI (Length, Regex, Choice, ChoiceIgnorecase, Equality, EqualityIgnorecase)
• Comparison (<, <=, =, > =, >, used only for Length
• Value, the value

Let's see an examples:

"name","L","<","10"
"surname","L","<","10"
"age","R","","\\d{1,3}"
"sex","SI","","F|M"
"programmer","U","","bertolottipf"

name must be length less then ten characters.
surname also must be length less then ten characters.
age must have from 1 to 3 numbers.
sex must be "M" or "F" but can also be in lowercase.
programmer must be "bertolottipf".

Into the spreadsheet you can copy cells with CTRL + mouse click (also dropping that one) and move from cells with CTRL + ALT + arrow buttons.
Right click on number rows can be usefull to delete rows.

Validator generator

Clicking "Generate new one" beside "File VAL" file selector, it's possible generate a new file validator. Right-mouse-click can be usefull to delete or edit regulars espressions and columns.