Please make yourself familiar with the functionsa available in FOCUS, they are all in the technical documentations.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
April 12, 2010, 01:05 PM
Darin Lee
Although you can use EDIT to put a smaller field into a larger one, you cannot put a larger field into a smaller one without using a mask. Dan's use of SUBSTR is probably the shortest way to get what you want. You could also use EDIT in the following manner to get the first 100 characters of the field (there are 100 9's)
The trailing $ signs are not necessary if you're just excluding al remaining characters. Refer to the documentation for proper use of the EDIT command.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat