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
Ryan-Dallas
posted on 25 Nov 18Enjoy 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
Post Comment