How do I export Oracle table data to a csv file

From: <reji.mathews_at_capita.co.uk>
Date: 10 Jan 2003 11:34:17 -0800
Message-ID: <38788d11.0301101134.2e0414ec@posting.google.com>

I am trying to export Oracle Data to csv file but it fails to export some of the data.
Following is the syntax I am using:

SET ECHO OFF HEADING OFF NEWPAGE 0 FEEDBACK OFF LINESIZE 10000 PAGESIZE 0 WRA OFF RECSEP OFF CON OFF TRIM ON TRIMS ON VERIFY off doc off

--FAQ.bat--

sqlplus -s userid/password_at_hoststring @faq.sql > faq.csv

--FAQ.sql--

select
'"'||FAQ_NUMBER ||'","'||FAQ_CATEGORY||'","'||QUESTION||'","'||ANSWER||'","'||RELATED_LINK||'","'||AUDIENCE||'","'||FAQ_VALID from FAQ_INFOBASE
order by FAQ_NUMBER;

exit

The column ANSWER has most of the special characters. Please Please help me out

--
Received on Fri Jan 10 2003 - 13:34:17 CST