How to remove newline characters in a big query table column
REPLACE works just fine in removing the newline characters:
SELECT Col_name, REPLACE(Col_name, '\\n', '') AS new_col FROM Tablename
Read great educational content like this and a lot more !
Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too