Recap: trying to get a 'dbs' extension file into R.
I tried most of the functions in the 'forgein' package. Nothing there
worked. Scan seemed to do the best. See below... I've tired using readBin()
for hours and I haven't extracted the value I want, price.
This example is a tiny sample dbs file that should have ticker, fye month,
company, split fact, and price, where ticker = 'IBM'; fye month='N/A';
Company='---------------'; split fact= '2.00' (5/27/99), '2.00' (5/28/97),
and 'N/A'; Price='165.25' (9/02/11). As you might have guessed this is stock
time series data on one stock (IBM). See the end of this email. I can see
the ticker and Company, but nothing else seems reveal itself.
to.read =scan("C:\\some_path\\one_test2.dbs","rb")
to.read[1:600]
[1] "VER" "3.7" "\b" "\002\017\b\b"
"*" "TICKER" "NZCIFYE" "FYE" "MONTH"
"NZCICNAME" "COMPANY" "NZCISPLITS" "SPLIT"
[14] "FACTNZP" "3" "PRICE" "XX"
"XX" "XX" "XX" "XX" "XX"
"XX" "XX" "XX" "XX"
[27] "XX" "XX" "XX" "XX"
"XX" "XX" "XX" "XX" "XX"
"XX" "XX" "XX" "XX"
[40] "XX" "XX" "XX" "XX"
"XX" "XX" "XX" "XX" "XX"
"XX" "XX" "XX" "XX"
> to.read[600:length(to.read)]
[1] "XX" "XX"
"XX" "XX"
"XX" "XX"
[7] "XX" "XX"
"XX" "XX"
"XX" "XX"
[13] "XX" "XX"
"XX" "XX"
"XX" "XX"
.......cont'd......
[565] "" ""
"" ""
"" ""
[571] "" ""
"" ""
"" ""
[577] "" ""
"" ""
"" ""
[583] "" ""
"" ""
"" ""
[589] "" ""
"" ""
"" ""
[595] "" ""
"" ""
"" ""
[601] "" ""
"" ""
"" ""
[607] "IBM ñØ---------------Jq" "@qn"
"@" "À\035tÉ"
Any ideas or suggestions? I'm thinking readBin() is the way to go but all I
get are meaningless numbers and the character strings you see above.
However, I think scan() with the "rb" is doing a similar thing to readBin().
(If you are curious, when using readBin() I'm using integer(), n = 100000,
size = 8 (but I've tried many others), and endian='little".)
Thank you so much for your help!
Ben
On Sat, Sep 10, 2011 at 1:50 PM, R. Michael Weylandt <
michael.weyla...@gmail.com> wrote:
> No experience with dbs files, but the foreign package might be able to help
> you out.
>
> Michael
>
> On Sat, Sep 10, 2011 at 2:44 PM, Ben qant <ccqu...@gmail.com> wrote:
>
>> Hello,
>>
>> I have a bunch of data files all with "dbs" file extensions. They are
>> generated via a SQL query from another program and source. Does anyone
>> know
>> (or have ideas) how to get the data from a dbs file type into R (or into
>> some other format that can imported to R)? I've searched online for 4
>> hours
>> now...
>>
>> Thanks!
>>
>> Ben
>>
>> [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help@r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
>
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
