# List of functions on columns

This table defines all the functions you can perform on columns in Talend Data Stewardship.

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

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 0, and 3.14 -> 3.2 if Precision is set to 1)

Round value using floor mode

numbers

Rounds value to the smallest integer (3.74 -> 3 if Precision is set to 0, and 3.74 -> 3.7 if Precision is set to 1)

Round value using halfup mode

numbers

Rounds value to the closest integer (3.14 -> 3 and 3.74 -> 4 for a Precision set to 0)

Round value using down mode

numbers

Rounds towards zero. (3.74 -> 3 and -3.74 -> -3 for a Precision set to 0)

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

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

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

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

For example ÃƒÂ¢Ã¢Â€ÂšÃ‚Â¬10.5k will become 105

Remove non numeric characters

For example ÃƒÂ¢Ã¢Â€ÂšÃ‚Â¬10.5k will become 10.5

Simplify text (remove case, accent, etc.)