Wednesday, March 4, 2026
Tip of the Day: Specify a Starting Row with the LOAD Command
Product: R:BASE 11
Build: 11.0.3.20226 or higher
Section: Commands
Keywords: LOAD, AFTER, Starting Row
The *LOAD* command has been enhanced to specify the starting row within
a source file.
This new capability is especially useful when working with files that
contain header information, comments, or other non-data rows at the
beginning of the file that should not be imported into the table.
*Syntax:*
LOAD <TableName> FROM <FileName> AFTER <n> ROWS
The AFTER <n> ROWS parameter directs R:BASE to begin processing rows
after skipping the first <n> rows in the source file.
* <n> must be a positive whole number.
* Processing begins with row <n + 1> in the file.
*Example:*
The following example loads the Calendar table while skipping the first
10 rows of the source file:
LOAD Calendar FROM CalUpdate275.txt AFTER 10 ROWS
If the file contains 1,685 total rows, R:BASE will skip the first 10
rows and load the remaining 1,675 rows into the Calendar table.
The AFTER <n> ROWS parameter is particularly helpful when:
* The file includes column headers in the first row
* The file begins with descriptive text or comments
* The file contains metadata or report headers that should not be imported
* A partial reload is required from a known row position
*Notes:*
* If AFTER <n> ROWS is not specified, processing begins at row 1
(default behavior).
* If <n> exceeds the number of rows in the file, no rows will be loaded.
* The parameter only affects the starting point; all subsequent rows
are processed normally.
The Support Team
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 visit
https://groups.google.com/d/msgid/rbase-l/c1825e4a-9f5b-5cdc-f705-2d4d48398b9b%40rbase.com.
