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
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds