I have an Oracle table that has a CLOB field (SCBDESC, SCBDESC_TEXT_NARRATIVE). When I output it as FORMAT EXL2K the data gets displayed in multiple rows rather than in one row, as if there are CRLF in there. The MFD was a USAGE=TX50; however, if I change it to USAGE=TX254 (the max) I still get multiple rows but more data per cell. This indicates to me that there are not CRLF in the data.
Changing the ouput to PCHOLD FORMAT ALPHA or COMMA or COMT gets a (FOC702) THE OPTION SPECIFIED IS NOT AVAILABLE WITH TEXT FIELDS:
The goal is to get the data out and import into another system. If I can get into Excel in one cell I know I can export it as a text file and then import it.
Any thoughts or help is appreciated.

This message has been edited. Last edited by: Rick Man,

You are limited to the FOCUS datatypes.

You can change the usage to Annnn, if you know it is going to be small.

Thanks Waz. I changed the MFD to A3500 anything over that I got an error on exceeding the length, blah blah blah. So that kind of works. If I run the SQL in TOAD and do a save as Excel it is fine. So being a one time shot (today anyway) guess what I'm going to do? But I do appreciate the help. Thanks again. Rick

Rick Man, have you been able to get clobs to print on reports? We are trying to use SSBDESC in a report. I tried changing the TX50 to A3500V. This works great but there is garbage on the end of the string (probably carrage controls, etc). Also, we would have to split the string into several parts to get it to print 'nicely'. Any help you can provide would be greatly appreciated. Thanks.

Paul - did you find a work-around for the issue you were having?

We have an Oracle table that has CLOB field and we are trying to output it in Excel format. If I choose to export as Excel Formula, it will put entire field in one cell, but it changes apostrophe and other special characters to some UNICODE numbers and also puts garbage at the end of the string.