Albert, I tried the steps listed below and had no success. It seems you
cannot set "tab" as a delimiter in Rbase.
Thanks for the input.
Gary
----- Original Message -----
From: "Albert Berry" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Tuesday, June 28, 2005 2:51 PM
Subject: [RBG7-L] - Re: Set Delimit
The next trick is to set the delimit character to the tab character.
SET VAR vTabChar = (CHAR(009))
SET DELIMIT=NULL
SET DELIMIT=.vTabChar
LOAD ... FROM ....
SET DELIMIT=NULL
SET DELIMIT=','
--- [EMAIL PROTECTED] wrote:
Thanks Albert, I have tried Gateway and the time to load the file is to
long. I was hoping to load the file without having to go through
Gateway.
Current size of file is 40,000 lines.
----- Original Message -----
From: "Albert Berry" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Tuesday, June 28, 2005 1:32 PM
Subject: [RBG7-L] - Re: Set Delimit
> Gary, if you use Gateway, you can pick the file format including tab
> delimited. Just type
> "GATEWAY" at the R> prompt, and follow the instructions.
>
> --- [EMAIL PROTECTED] 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.
>>
>> Thanks
>> Gary
>
>
> Albert Berry
> Management Consultant
> RR2 - 1252 Ponderosa Drive
> Sparwood BC, V0B 2G2
> Canada
> (250) 425-5806
> (250) 425-7259
> (708) 575-3952 (fax)
> [EMAIL PROTECTED]
>
>
Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]
