Or just use $OPTIONS EXTRA.DELIM. This ensures that an empty element is still added with the correct delimiter.
Brian In message <[EMAIL PROTECTED]>, Allen E. Elwood <[EMAIL PROTECTED]> writes >You can always test, > >IF TEMP = '' THEN TEMP = "NULL" > >and likewise on the end that processes after the ARRAY is completed. > >1~2~NULL~4~5~NULL~... > >on the receiving end would be > >IF ARRAY<WHATEVER> = "NULL" THEN ARRAY<WHATEVER> = "" If you're going to do that, use (I think) EREPLACE. I think it's that function, but there's certainly one to remove all occurrences of a particular text. The danger is that the letters NULL will be part of a value which then gets corrupted... I always did ARRAY := @FM : WHATEVER and then at the end did DEL ARRAY<1> Cheers, Wol -- Anthony W. Youngman <[EMAIL PROTECTED]> 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - <http://www.maverick-dbms.org> Open Source Pick ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
