问雪花:使用单个Regex_replace替换多个模式

EN

create or replace function CLEANUP_STRING(STR string)
returns string
language javascript as
$$
    var s = STR.replace(/[,\t\n]/g, "");  // Replace comma, tab and new line character to empty
    s = s.replace(/"/g, "'");             // Replace double quote with single quote
    s = s.replace(/\|/g, "-");            // Replace pipe with dash
    return s;
$$;

-- This will display in black font, showing that the line break is gone.
select cleanup_string('This is a "double quoted string". This has a | pipe. This has a new \n line. This has a, comma.');