Data Fields

Commands for modifying CSV Table fields

This program offers the possibility to modify individual fields (columns) of a CSV file.
For this purpose all contents of other fields in the same row are available, as well as arithmetic operations, regular expressions (regex) and formatting options.

±set
Sets one or more CSV table fields to a certain value
±init
Sets one or more CSV table fields to a certain value, if they are empty
±prepend
Prepends some content to an existing CSV data field (column)
±append
Appends some content to an existing CSV data field (column)
±insertat
Inserts a new expression into a CSV table field at a defined position
±replace
Replaces parts of a CSV table field with a replacement expression
±replaceat
Replaces a position-defined part of a CSV table field with a replacement expression
±remove
Removes one or more parts of a CSV table field
±removeat
Removes a position-defined part of a CSV table field
±trim
Removes preceding or trailing whitespace of a CSV table field
±clear
Empties a CSV table field
±regex
Modifies a CSV table field content using a regular expression
±if/else
Allows conditions for working on CSV data fields