±removeat
Removes a position-defined part of a CSV table field
Description
Removes certain sections of a data field.The portion to remove is defined via start position and length, or via start and end.
When there are several parts to remove in one command. the remove definition parts are separated by commas.
The overall length of the data field will change accordingly.
The start position begins with 1.
The start and stop definition should be enclosed with brackets to hide any comma from the comma-separated list.
Removing one part of one data field
Pattern
±removeat[Field]=(start-stop)
±removeat[Field]=(start+length)
-removepos[field]=(3-8) removes the characters from position 3 to 8.
-removepos[field]=(3+8) removes 8 characters, starting from position 3. (i.e., it removes positions 3 to 10.)
Removing the same position part from multiple data fields
Pattern
±removeat[Field],[Field]-[Field],...=(start-stop)
±removeat[Field],[Field],...=(start+length)
When more data fields are given as a list, then the same removing of characters will be applied to all data fields in this list.
When the special field name [*] is used, this means that removement will take place in all data fields of the current table row.
Removing multiple parts of the data field`s contents
Pattern
±removeat[Field]=(start-stop),(start-stop),...
±removeat[Field],[Field],[Field]=(start+length),...
±removeat[Field]=(start-stop)/(start-stop),...
You can also remove more than one content part. To achieve this, all parts to remove (start-end, start+length) are given as a comma-separated list.