Tuesday, October 12, 2021
Tip of the Day: Import Files with a Custom Record Separator
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.4.11007 or higher
Sections......: Commands, File Gateway
Keywords......: Import, Record Separator, Carriage Return, Line Feed)
Did you know that you can import data files into R:BASE tables
and a custom record separator may be specified?
A new REC_SEP parameter has been added to the GATEWAY IMPORT
command to specify custom record separator values.
The common value is CRLF (carriage return + line feed), which
moves the parser down to the next line and then to the beginning
of the line. A custom record separator can now also be specified.
Available Parameters: CRLF / CR / LF / <Custom>
GATEWAY IMPORT CSV Titles.csv REPLACE Titles OPTION REC_SEP CR
The File Gateway Import Wizard has also been updated to optionally
specify custom Record Separator and Text Qualifier values. The drop-
down menus will accept a custom entry by typing in a value.
Handling automated import jobs from various sources is always a task,
and allowing to specify a custom record separator will keep you ready
for those changing conditions!
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1Mt7Y5-1mtjXB0BNB-00tVFk%40mrelay.perfora.net.
