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 way to convert it.
In your example, are you really getting "XX" for all entries, or are you obfuscating the data? Sarah On Sat, Sep 10, 2011 at 7:54 PM, Ben qant <ccqu...@gmail.com> wrote: > 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 >> -- Sarah Goslee http://www.functionaldiversity.org ______________________________________________ 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.