Tuesday, April 21, 2009 Tip of the Day #4: Defining Column Count When Importing Data
Section: Enhanced GATEWAY IMPORT Command Options Supported Versions: . R:BASE 7.6 for Windows (Build: 7.6.7.30420 or higher) . R:BASE Turbo V-8 for Windows (Build: 8.0.21.30420 or higher) . R:BASE eXtreme (v9) for Windows (Build: 9.0.1.10420 or higher) Did you know that while automating the entire File Gateway Import routines to import MS Spreadsheet (.xls) or .CSV file into R:BASE, now you can specify the exact number of columns to import? An additional "OPTION COLUMN_COUNT nnn" has been implemented to fully automate your entire load process, using the latest updates of R:BASE 7.6, Turbo V-8, and R:BASE eXtreme 9.0 (32/64). -- Example: GATEWAY IMPORT filename.csv CREATE newtable OPTION COLUMN_COUNT 5 This command will import only first 5 columns from CSV file. Very Best R:egards, Razzak
