Hello Razzak, Great enhancement. Thank you!
Regards, Ken On Mon, Nov 22, 2021 at 4:07 PM A. Razzak Memon <raz...@rbase.com> wrote: > Monday, November 22, 2021 > > Tip of the Day: Assign NULL Values as Blank in Exports > Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) > Build.........: 10.5.4.11118 or higher > Sections......: File Gateway > Keywords......: Export, NULL, GATEWAY, BLANK_IF_NULL, Blank > > Did you know that NULL values may be displayed as blanks in > table exports? > > A new "NULL Values Export as Blanks" option was implemented > within the File Gateway Export menu, so your NULL value > (e.g. -0-, NULL, etc.) is not displayed. > > The new option is different from the now "Zero Values Export as > Blank" option, which is specific to zero values being assigned > as a blank. The Export Wizard also includes a new "Blank if Null" > option for the desired output. > > A new EXPORT parameter, BLANK_IF_NULL, has also been added to > the GATEWAY command to assign NULL values as a blank. > > GATEWAY EXPORT XLSW C:\Temp\CustomerContacts.xlsx + > SELECT ALL FROM CustomerContacts + > OPTION COL_NAMES ON + > |SHOW_PROGRESS ON + > |BLANK_IF_NULL ON > > The Data Browser settings also includes the new "Blank if NULL" > setting for exports performed at the table level. > > Very Best R:egards, > > Razzak. > > R:BASE Technologies, Inc. > https://www.rbase.com > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rbase-l+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/0LoWaK-1mABD537VK-00gYbU%40mrelay.perfora.net > . > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CADeqk-7qRKc8%3DWeAQxAiWo8jDuLyD6TWxdEX8OAr%3DLfXd4nDug%40mail.gmail.com.