Skip to main content

DB_Column.fill_empty

fill_emptydefault

Group: Values
Aliases: fill empty, if_empty

Documentation

Returns a new column where empty Text values have been replaced with the provided default.

Arguments

  • default: The value to replace empty values with. If this argument is a column, the value from default at the corresponding position will be used. If this argument is Previous_Value, the empty values will be replaced with the previous value in the column. Note that the first rows may stay empty if they do not have a previous value to use.

Examples

Fill empty values in a column with the value "hello".

      import Standard.Examples

example_fill_empty = Examples.text_column_1.fill_empty "hello"