Version

    6. Transformation steps

    Data set manipulation steps
    Add column
    Duplicate column
    Delete column
    Rename column
    Reorder columns
    Filter rows based on formula
    Sort
    Lookup
    Calculate formula
    Text manipulation steps
    Left substring
    Right substring
    Substring
    Trim
    Pad left
    Pad right
    Remove whitespaces
    Remove accents
    Lowercase
    Uppercase
    Remove non-alphanumeric characters
    Remove non-ASCII characters
    Remove non-numeric characters
    Remove non-printable characters
    Replace text
    Error handling steps
    Remove rows with errors
    Replace errors
    Replace empty values
    Clear error cells
    Math steps
    Absolute value
    Round step
    Truncate
    Square root
    Exponential
    Raise number to a power
    Natural logarithm
    Common logarithm
    Ceiling
    Floor
    Division remainder
    Date manipulation steps
    Current date and time
    Data conversion steps
    Convert to boolean
    Convert to date
    Convert to decimal
    Convert to integer
    Convert to string
    Convert Unix time to date

    Wrangler implements a large number of steps that help you work with your data - steps that clean your values, compute mathematical formulas, and more.