Have two fields in a data source where word/string "null" is stored as a text/string value as part of a SQL compare process. Word "null" appears in report display, but expecting a blank or empty field there. Is there an easy way to replace a string value with another string value "NULL" to NULL within WF?
Thanks!This message has been edited. Last edited by: Kerry,
7.6.4 XP SP3 EXL2K, HTML, PDF
June 11, 2009, 03:02 PM
Francis Mariani
Use a COMPUTE or DEFINE to change the "null" string to blank.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
June 12, 2009, 09:18 AM
ta2007
Sorry. I should have closed this earlier. Right after I posted I remembered how to do it. Sometimes it is the easy things we forget. I was trying to make it way too complex.
I used an 'if...then' within a define. Thanks for the response.
7.6.4 XP SP3 EXL2K, HTML, PDF
June 12, 2009, 11:57 AM
Darin Lee
If you really need a NULL value instead of blanks, use MISSING ON:
FIELD2/A10 MISSING ON=IF FIELD1 EQ 'NULL' THEN MISSING ELSE FIELD1;
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