I have a SQL Server database that has a field defined as an NTEXT format and in WebFOCUS as USAGE=TX50, ACTUAL=TX.
When I create an Excel format output the data spans multiple rows.
1. I would prefer all the data to be in one cell in one row.
And
2. If I want to truncate it, when I use the EDIT function I don't get any data.

How can achieve both results?

Hi rjmman,

If the NTEXT field is less than 4000 bytes you should be able to use

Usage An Actual An

where n is an integer between 1 and 4000.

Hope this helps.

Cheers,

Kerry

quote:

Originally posted by rjmman:
I have a SQL Server database that has a field defined as an NTEXT format and in WebFOCUS as USAGE=TX50, ACTUAL=TX.
When I create an Excel format output the data spans multiple rows.
1. I would prefer all the data to be in one cell in one row.
And
2. If I want to truncate it, when I use the EDIT function I don't get any data.

How can achieve both results?

Thanks. I ended up created 2 new fields a short and a long. I could have just created the long and used EDIT.
FIELDNAME=DESCRIPTION, ALIAS=DESCRIPTION, USAGE=TX100, ACTUAL=TX,
TITLE='Full Description',
MISSING=ON, $
FIELDNAME=DESCRIPTS, ALIAS=DESCRIPTION, USAGE=A100, ACTUAL=A100,
TITLE='Short Description',
MISSING=ON, $
FIELDNAME=DESCRIPTL, ALIAS=DESCRIPTION, USAGE=A4093, ACTUAL=A4093,
TITLE='Long Description',
MISSING=ON, $