Razzak, thanks, I have used the Gateway function, however, with one table
having the potential of 90,000 lines to update each week it is time
consuming. I was trying to find a faster way. I currently upload using the
csv method, this requires me structuring the data in separate spreadsheets
due to Excel limitations and the way the data is dropped from host system.
I remove the header and cleanup some of the columns that are not needed,
save the file as csv and use the Load command in Rbase. I was trying to
avoid going thru another program and providing data direct to RBase for
loading.
My options for downloading are Excel, Text(tab delimited), Access, HTML. I
have a somewhat limited download approach.
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Wednesday, June 29, 2005 11:26 PM
Subject: [RBG7-L] - Re: Set Delimit
At 02:08 PM 6/28/2005, Gary Wendike wrote:
I have a text file that I am trying to load, however the delimiter is
"tab" and the "coma".
How do I reset the delimiter to tab in a command file.
Gary,
To load the ASCII Tab Delimited file, use the command line
GATEWAY IMPORT option.
Assuming that you have the target table to match with the
ASCII Delimited file.
Examples:
-- To import data as new table
GATEWAY IMPORT TAB filename.TAB CREATE newtablename
-- To append imported data in existing table
GATEWAY IMPORT TAB filename.TAB APPEND existingtablename
-- To replace existing table data
GATEWAY IMPORT TAB filename.TAB REPLACE existingtablename
Hope that helps!
Razzak.
