daft.functions.translate#

def translate(
    expr: Expression,
    from_str: str | Expression,
    to_str: str | Expression,
) -> Expression:
    """Translates characters in the input string by replacing characters in 'from_str' with corresponding characters in 'to_str'.

    Characters in 'from_str' without a corresponding character in 'to_str' are removed.
    This is compatible with Spark's translate function.

    Args:
        expr: The string expression to translate
        from_str: Characters to be replaced
        to_str: Replacement characters

    Returns:
        Expression: a String expression with characters translated

    Examples:
        >>> import daft
        >>> from daft.functions import translate
        >>> df = daft.from_pydict({"x": ["AaBbCc", "hello", "world"]})
        >>> df = df.select(translate(df["x"], "abc", "123"))
        >>> df.show()
        ╭────────╮
        │ x      │
        │ ---    │
        │ String │
        ╞════════╡
        │ A1B2C3 │
        ├╌╌╌╌╌╌╌╌┤
        │ hello  │
        ├╌╌╌╌╌╌╌╌┤
        │ world  │
        ╰────────╯
        <BLANKLINE>
        (Showing first 3 of 3 rows)

    """
    return Expression._call_builtin_scalar_fn("translate", expr, from_str, to_str)