SQLPLUS help

I have a query to extract for some migration purpose.

select number,name,notes from table_name
where number=1;

I want it to be csv and pipe delimited

When I extract it from toad export data set I get the output as correct

Number|Name|Notes
123456|Oracle user|Hello Oracle user,  You have a notice to pay immediately from Oracle Recevables. Thanks, Regards, --Oracle Receivables Controller India Phone nu:9999999 email: oracleuser1@ymail.com, website : www.oracle.com

But in Toad if I connect to SQLPLUS and run this one

SET SERVEROUTPUT ON SIZE 1000000
SET LINES 5000
SET PAGES 10000
set trimspool on