This is an old revision of the document!
A basic mass edit command is comprised of three selectors and an operation.
A more advanced mass edit command can instead perform a row operation.
Selection in each category can be controlled more precisely by using the && characters to combine multiple selection criteria.
Row and field operations can make use of operation arguments, which return a value that can then be operated on.
Variables can be used to hold a value.
| Usage | Description |
|---|---|
| clear | Clears clipboard param and rows. |
| newvar <name> <value> | Creates a variable with the given value, and the type of that value. |
| clearvars | Deletes all variables. |
| Usage | Description |
|---|---|
| self | Gives the value of the currently selected value. |
| field <field> | Gives the value of the given cell/field for the currently selected row and param |
| vanilla | Gives the value of the equivalent cell/field in the vanilla regulation or parambnd for the currently selected cell/field, row and param. Will fail if a row does not have a vanilla equivalent. |
| aux <parambank> | Gives the value of the equivalent cell/field in the specified regulation or parambnd for the currently selected cell/field, row and param. Will fail if a row does not have a aux equivalent. Consider using && !added |
| vanillafield <field> | Gives the value of the specified cell/field in the vanilla regulation or parambnd for the currently selected cell/field, row and param. Will fail if a row does not have a vanilla equivalent. Consider using && !added |
| auxfield <parambank> <field> | Gives the value of the specified cell/field in the aux regulation or parambnd for the currently selected cell/field, row and param. Will fail if a row does not have an aux equivilent. |
| paramlookup <param> <row> <field> | Returns the specific value specified by the exact param, row and field. |
| average <field> <row selector> | Gives the mean value of the cells/fields found using the given selector, for the currently selected param. |
| median <field> <row selector> | Gives the median value of the cells/fields found using the given selector, for the currently selected param |
| mode <field> <row selector> | Gives the mode value of the cells/fields found using the given selector, for the currently selected param. |
| min <field> <row selector> | Gives the smallest value of the cells/fields found using the given selector, for the currently selected param. |
| max <field> <row selector> | Gives the largest value of the cells/fields found using the given selector, for the currently selected param |
| random <min> <max> | Gives a random decimal number between the given values for each selected value. Minimum and maximum are inclusive. |
| randint <min> <max> | Gives a random integer number between the given values for each selected value. Minimum and maximum are inclusive. |
| randFrom <param> <field> <row selector> | Gives a random value from the cells/fields found using the given param, row selector and field, for each selected value. |
| paramIndex | Gives an integer for the current selected param, beginning at 0 and increasing by 1 for each param selected. |
| rowIndex | Gives an integer for the current selected row, beginning at 0 and increasing by 1 for each row selected. |
| fieldIndex | Gives an integer for the current selected field, beginning at 0 and increasing by 1 for each field selected. |