Data Filtering - bradmartin333/XferSuite GitHub Wiki

Find this tool in the Advanced Tools menu of XferSuite

Example Usage

IF Pass OPER 0 POW 3

image

DELETE 27 IN 0

image

COLS

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

COUNT

  • 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

  • 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

  • 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

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

NOT

  • NOT and NOTEX behaves just like IF but inverse

EVAL

  • 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

  • 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

FIRST

  • Deletes all but the first item in the dataset

LAST

  • Deletes all but the last item in the dataset

BETWEEN

  • 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, (, )