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]
