Trim Whitespace — Solution & ExplanationProblems / Trim Whitespace / EditorialApproachThe TRIM() function removes leading and trailing whitespace from a string. Apply it to every text column that needs cleaning.SQL```sqlSELECTcontact_id,TRIM(first_name) AS first_name,TRIM(last_name) AS last_name,TRIM(email) AS email,TRIM(phone) AS phoneFROM contacts```DuckDB also supports LTRIM() (left only) and RTRIM() (right only) if you need to remove whitespace from just one side.Hints

SQL provides TRIM(), LTRIM(), and RTRIM() functions for whitespace removal.

TRIM() removes both leading and trailing whitespace in one call.

In PySpark, F.trim() does the same thing as SQL's TRIM().

Solve Trim Whitespace yourself →