Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!think.com!hsdndev!bbn.com!aoa!rich From: rich@aoa.UUCP (Rich Snow) Newsgroups: comp.sys.ibm.pc.programmer Subject: SDF database format, ever heard of it? Keywords: HELP me translate SDF data Message-ID: <1502@aoa.UUCP> Date: 10 Apr 91 19:02:58 GMT Distribution: usa Organization: Adaptive Optics Associates, Cambridge Mass. Lines: 27 I have been given a pile of disks with ASCII files in SDF format. (That is they're .SDF files) My eventual goal is to transport this data into a Mac spreadsheet. I have no problem with the hardware end of this, but can anyone tell me, what the "%$&^*&" is SDF format? Is there any translator to another native PCish format? (Tab, DBF, Comma, etc) The fields in each record seem to be delimited with white space, but not tabs. They are seperated with spaces. The fields are not of a common length. It looks like the only way to extract it is to trash the first 3 chars, and grab everything up to the first " ", then search for a "/" since the end of the second field and the beginning of the third are seperated by a "/" and then to index backwards two space chars. That would put me at the beginning of the second field... Very messy. Seen this before? -Rich -- * Rich Snow AOA-----------------* * (617)864-0201 * ...!{decvax,linus,ima,ihnp4}!bbn!aoa!rich * aoa!rich@bbn.com