Create a new action to automatically substitute contents

[clinaresl]

Many times, in sps2db it might happen that some contents are unnecessary so that it might be useful to substitute them by other data in the database. This happens for example in the grades of UC3M where the absence of a score is given with '-' by Aula Global while the database needs a different value such as 0.

For this a command inspired by sed (or better said, copied from sed) is suggested:

"s/old-data/new-data"

where sps-data is a regular expression. In case it matches the input from the spreadsheet then it is automatically substituted by the literal new-data. For example, to substitute '-' by 0 one could define a column as follows:

ex1 $A2:$A. integer s/-/0;