IF Pass OPER 0 POW 3

DELETE 27 IN 0

COLS prints the header (If available), the column indices and if the column is numerical

• COUNT returns the number of active rows
• COUNT 3.14 returns the number of active rows that contain 3.14 in at least one column
• COUNT 3.14 IN 2 returns the number of active rows that contain 3.14 in column index 2
• COUNTEX 3.14 returns the number of active rows that contain exactly 3.14 in at least one column
• COUNTEX 3.14 IN 2 returns the number of active rows that contain exactly 3.14 in column index 2

• DELETE removes all active rows
• DELETE 3.14 removes active rows that contain 3.14 in at least one column
• DELETE 3.14 IN 2 removes active rows that contain 3.14 in column index 2
• DELETEEX 3.14 removes active rows that contain exactly 3.14 in at least one column
• DELETEEX 3.14 IN 2 removes active rows that contain exactly 3.14 in column index 2

• REPLACE 3.14 999 replaces any appearance of 3.14 with 999 for active rows
• REPLACE 3.14 999 IN 2 replaces any appearance of 3.14 with 999 in column index 2 for active rows
• REPLACEEX 3.14 999 replaces any exact appearance of 3.14 with 999 for active rows
• REPLACEEX 3.14 999 IN 2 replaces any exact appearance of 3.14 with 999 in column index 2 for active rows
• REPLACE ANY 999 IN 2 replaces anything in column index 2 with 999 for active rows (Can only use ANY for specified columns)
• Use NULL for empty like this REPLACE ANY NULL IN 2

• IF and IFEX behaves just like the above commands
• When matched by IF or IFEX the row is activates

• NOT and NOTEX behaves just like IF but inverse

• EVAL 2 GR 3.14 activates rows where the value in column index 2 is greater than 3.14
• Available evaluators are GR, LS, GREQ, LSEQ, EQ, NEQ

• OPER 2 + 3.14 adds 3.12 to the column index 2 for all active rows
• Available operators are ADD, SUB, MUL, DIV, MOD, POW, RND

• Deletes all but the first item in the dataset

• Deletes all but the last item in the dataset

• BETWEEN deletes all between the first and last items in the dataset
• BETWEEN 2 deletes all between the second and last items in the dataset
• BETWEEN 2 4 deletes all between the second and (2+4+1)th item in the dataset (Data = Data.Skip(a).Take(b).ToList())

The down arrow clears the entry box and the up arrow loads the last valid command

The following strings are ignored for user convenience: row, col, (, )