On a similar vein, I have used a field terminator or "," (double quote comman double quote).

The downside to this is that the first double quote and the last double quote in the line are not removed so I had to remove them with string manipulation.

select substring(col1,1,len(col1)-1),...., left(collast,len(collast)-1)

etc.

Jeremy