How to remove newline characters in a big query table column
REPLACE
works just fine in removing the newline characters:
SELECT\n Col_name,\n REPLACE(Col_name, '\\n', '') AS new_col\nFROM Tablename\n
Ryan-Dallas
posted onEnjoy 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