# List of functions on columns

Name |
Category |
Description |
---|---|---|

Negate value |
boolean |
Reverses the boolean value of cells from this column |

Concatenate with |
columns |
Merges the content of this column with another one, and displays the content in a new column |

Convert country names and codes |
conversions |
Converts a country name to an ISO-3166 country code (alpha-2, alpha-3 or numeric) or vice versa |

Convert distance |
conversions |
Convert distance measurement units |

Convert duration |
conversions |
Convert time duration measurement units |

Convert temperature |
conversions |
Converts temperature measurement units |

Clear on matching value |
data cleansing |
Clears cells that match the value |

Clear the cells with invalid values |
data cleansing |
Clears cells that contain a value recognized as invalid |

Delete the rows with empty cell |
data cleansing |
Deletes rows that have empty cells |

Fill cells with value |
data cleansing |
Fills cells from this column with a given value |

Fill empty cells with text |
data cleansing |
Fills empty cells from this column with a given value |

Fill invalid cells with value |
data cleansing |
Fills cells from this column with a given value |

Standardize value (fuzzy matching) |
data cleansing |
Replaces invalid values in the column with the closest correct value from the dictionary-bases semantic type referenced by the column |

Convert date |
dates |
Convert date measurement units |

Modify date |
dates |
Adds or subtracts time unit amount |

Calculate absolute value |
math |
Calculates the absolute value for all the numeric values in this column. |

Modulo |
math |
Calculates the reminder of a division operation |

Negate |
math |
Negates a column number |

Add, multiply, subtract or divide |
math |
Performs an operation/calculation on this column with another one or with a fixed value: Add/sum (+), multiply (x), subtract (-), or divide(/) |

Remove fractional part |
numbers |
Rounds towards zero. (3.74 -> 3) and (-3.74 -> -3) |

Remove negative values |
numbers |
Replaces negative integer or decimal values with empty values |

Round value using ceil mode |
numbers |
Rounds value to the largest integer (3.14 -> 4 if
Precision is set to |

Round value using floor mode |
numbers |
Rounds value to the smallest integer (3.74 -> 3 if
Precision is set to |

Round value using halfup mode |
numbers |
Rounds value to the closest integer (3.14 -> 3 and 3.74 -> 4 for a
Precision set to |

Round value using down mode |
numbers |
Rounds towards zero. (3.74 -> 3 and -3.74 -> -3 for a
Precision set to |

Format phone number |
phones |
Formats a phone number to the selected format |

Change to lower case |
strings |
Converts all of the cell text in this column to lower case |

Change to title case |
strings |
Converts the text content from this column to title case (i.e. "data prep" -> "Data Prep") |

Change to upper case |
strings |
Converts all of the cell text in this column to UPPER case (capitalize) |

Remove part of the text |
strings |
Removes specified text from cells in this column |

Remove consecutive characters |
strings |
Removes repeated characters (i.e. spaces) |

Search and replace |
strings |
Replace cells or parts of cells which contain a specific value |

Remove trailing and leading characters |
strings |
Removes trailing and leading spaces (i.e. trim) |

Replace the cells that match |
strings |
Replaces the cells that have a specific value |

Convert character width |
strings advanced |
Convert the character width to half or full width, or normalize strings. |

Add extra characters |
strings advanced |
Adds extra characters (padding) on the left or on the right of the original value to match an expected size |

Remove non alpha numeric characters |
strings advanced |
For example ÃƒÂ¢Ã¢Â€ÂšÃ‚Â¬10.5k will become 105 |

Remove non numeric characters |
strings advanced |
For example ÃƒÂ¢Ã¢Â€ÂšÃ‚Â¬10.5k will become 10.5 |

Simplify text (remove case, accent, etc.) |
strings advanced |
Simplifies the content of this column (i.e. François -> francois) |

Apply survivorship rule |
survivorship |
Decides what value to use to build the master record |

## Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!