|
Gary,
The file that contains the data to load into Rbase must be either comma
seperated or tab seperated. If you see commas seperating the fields, it's csv.
If you see no commas seperating the data. If it's tab delimited hen the
following example will help you. (assuming you know the record layout of the
incoming data)
load &vtable fro &vfile as formatted using + Sextion 1 2+ Block 3 7+ LotSa 8 23+ TwpCode 24 24+ School 25 27+ TaxYear 28 29+ PetNum 30 39+ PetStreetB 40 64+ Prop_Town 65 84+ Prop_Zip 85 93+ Petitioner 94 160 This
example shows the fields from the table being loaded. There are 11 fields and
the numbers following the fields show the start and end position of the incoming
data.
The
layout above should match the table layout and the incoming data record layout.
The example above shows a record length of 160.
In
the example above the field SEXTION starts at position 1 and ends at
position 2 in the incoming data file, so on and so forth.
Call
me if you need further explanation.
Bill Eyring
Authorized R:Base Developer
Mineola NY 11501
516-739-8080
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 28, 2005 1:09 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Set Delimit 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
|
