Tuesday, June 21, 2022
Tip of the Day: Specifying No Text Qualifier for GATEWAY Command Exports
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.4.20616 or higher
Sections......: Commands
Keywords......: GATEWAY, Export, QUALIFIER, NONE, CSV, TAB, SQL
Did you know that the GATEWAY EXPORT command was enhanced to specify
NONE as a valid value for the QUALIFIER parameter?
In the Export Wizard, there has always been a menu option to select
"None" as the text qualifier. However, when choosing to perform an
export using the command syntax, there is not a NONE option for the
QUALIFIER parameter.
Support is now added for the GATEWAY EXPORT command to specify NONE
as a valid value for the QUALIFIER parameter, for CSV, TAB, and SQL
file formats.
GATEWAY EXPORT CSV StorageUnits.csv +
SELECT * FROM SUnits +
OPTION BLANK_IF_ZERO OFF +
|SHOW_PROGRESS ON +
|QUALIFIER NONE
The QUALIFIER parameter specifies the text qualifier for fields in
the target export file. The popular value is quotes ("), but you can
define any custom character you wish. Use the keyword PIPE as the
value if you wish to use the pipe character (|)as the qualifier. Use
the keyword NONE if you wish to specify no text qualifier.
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/1MMX5X-1oMfTl18PX-00JZwH%40mrelay.perfora.net.