±trim

Removes preceding or trailing whitespace of a CSV table field

Trimming a single data field
Trimming more data fields
Trimming all data fields

Description

Removes prepending and/or whitespace sections or other characters of one or more data fields.

Per default whitespace before and behind the content is removed.

Supported options

Options /l (left) and /r (right) are supported.

±trim/l removes only prepending whitespace
±trim/r removes only trailing whitespace

When no parameter is given, any whitespace characters (space, Tab, Newlines) will be removed.
Alternatively, you can give a number of characters that shall be removed from start and/or from end of the fields(s).

Trimming a single data field

bla

Pattern

±trim[Field] ±trim/l[Field]=(characters to remove) ±trim/r[Field]

Usage examples

Trimming more data fields

Pattern

±trim[Field],[Field]-[Field], ... ±trim[Field],[Field]-[Field]=(characters to remove) ±trim/r[Field]

Usage examples

Trimming all data fields

When the pseudo column "[*]" is denoted, the ±trim command processes all data field of the table row.

Pattern

±trim[*] ±trim/l[*]=(Characters to remove) ±trim/r[*]

Usage examples

bla