SELECT RAPPORT
COPY TO "export.csv" DELIMITED WITH "|"

but the thing is a still get the , for delimiter

50668,| School A|,|Jennifer|

i want to eliminate the ,