Re: [R] DBS to R

2011-09-10 Thread Ben qant
The below is how scan() printed it in R...no obscured data here. I'm guessing that the 'XX's are place fillers because I read in only one ticker. The true 'source' is an SQL query. The other program isn't anything anyone would know about here. Thanks for any suggestions, ben On Sat, Sep 10, 2011

Re: [R] DBS to R

2011-09-10 Thread Sarah Goslee
I'm assuming you don't have access to the original program and source, but do you know what it is, and what version? (If you do have access to the original, then just export it in a different format.) The identity of the program would definitely help in reverse-engineering the format or finding a w

Re: [R] DBS to R

2011-09-10 Thread Ben qant
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 t

Re: [R] DBS to R

2011-09-10 Thread R. Michael Weylandt
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 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 anyo

[R] DBS to R

2011-09-10 Thread Ben qant
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 ho