Hi,

I have to concatenate two A360 fields to produce an output.
Some records have these fields as empty/null and as a result on concatenation I get garbage values.
I have tried using TRIM before concatenation; STRIP after concatenation; IS-MISSING and replacing before concatenation, but none of them have worked.

Please help..

Thanks

Have you tried passing the values separately in a hold file then concatenating from that point? I've found WebFOCUS will pass missing on as blanks or zeroes based on the format when coming out of a hold file.

Try

SET HOLDMISS=ON

or

ON TABLE SET HOLDMISS ON

This seems to do the trick.

Here's a working example, just change the setting to OFF or ON to see the difference.

SET HOLDMISS=OFF
SET HOLDLIST=PRINTONLY
TABLE FILE CAR
SUM
SALES
MODEL/A360
CAR/A360
FOR COUNTRY
'ENGLAND' OVER
'FRANCE' OVER
'CANADA'
ON TABLE HOLD AS H001 
END
-RUN
DEFINE FILE H001
TEST1/A720 = MODEL | CAR;
END
TABLE FILE H001
PRINT 
E01
SALES
TEST1
END
-RUN