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.