Is there a way i can export a selected section of table data and store it in the format of dbexport?

so far i have tried concatnating each column of the tables and using "|" as delimiter, but the text file would auto-format itself, so i am not getting one entry per line.

dbexport would work but i just want a portion of our product db data for testing, and i don't need the old table schema.

any suggestions?

Mark

Hi,
try
unload to xxx.unl
select * from table