Is there a corresponding function to the SQL, NVL function? I see a COALESCE, but it appears to be only for the Data Migrator.
And the issue is a NULL character. Maybe its DECODE. Can DECODE handle a NULL? I'll test it.

Thanks,

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

Any suggestions please..

How about:

  
DEFINE FILE filename
field/format MISSING ON = IF field IS MISSING THEN value ELSE field;
END

Rickman. Did you solve the problem. Please post your experience here.

Thanks..

Sorry. I hope to test this by the end of the week.

Ok. Please post if you get to find something.

thanks..

That technique did not work. See this post that does work.
http://forums.informationbuild...?r=25610394#25610394