Transform string¶
Perform a variety of encoding, decoding, and string transformations on one or several columns. Transformations are always done in-place. For more advanced transformations, use the Formula processor.
Options¶
Column
Apply transformation to the following:
A single column
An explicit list of columns
All columns matching a regex pattern
All columns
Mode
Select transformation to apply:
Convert to uppercase/lowercase: convert all text to upper or lower case
Encode/decode URL: form URL escape (
nice 7%
->nice%207%25
) or unescape (nice%207%25
->nice 7%
)Escape/unescape XML entities: replace
<
,>
, and&
by<
,>
and&
respectively in XML stringsEscape/unescape Unicode values: replace Unicode characters by their codepoint:
é
->\u00e9
or the oppositeRemove leading/trailing whitespace: trim
Capitalize: put a capital letter at the beginning of each cell
Capitalize every word: put a capital letter at the beginning of each word in the cell
Normalize: convert to lowercase, remove accents, and perform Unicode normalization (
Café
->cafe
)Truncate: keep only the first N characters of the cell