Bernie, I see what you mean that the ASCII fixed field option is no longer there on the Import/Export.
If you are doing the same load and unload over and over, you should just write a short program file to automate it for you. To bring your data in, use the LOAD TABLELNAME FROM FILESPEC AS FORMATTED USING CO11 start end, col2 start end..... command. If you save this in a file, you don't have to select the fields and locations every time you need to load a file of the same format. A very easy way to unload a fixed field file is with the select statement. You will want to make a few setting changes, but try something like this: set widht 240 -- you can make a file up to 240 char wide set line 0 -- get rid of page breakds set heading off -- get rid of headings set selmargin 1 -- have the first field start at position one. out somefile.txt select col1=5, col2=10, col3=15 from sometable where..... out screen This will give you a fixed field file where col1 is 5 char wide, col2 is 10, col3 is 15. I don't think this is the answer you wanted, but it should work for you. FYI these commands will work in both DOS and Windows. Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of BKarmel Sent: Saturday, June 28, 2003 2:07 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Export of ASCII Fixed file of table data Troy, thanks for the encouragement. I am loath to mess with paths using the DOS version under Windows. VEry cumbersome. So, I started to use the 6.5 windows to convert one of my DBs and found it very easy and straight forward at least for Tables and for Forms. I have not tried to convert any applications yet, but when I went to use the input/output utility where I can specify exact field placements and sizes for my variable list, as is possible using the ASCII .FIXed selection under TOOLS: inport/export as in either 4.5 or 6.5 DOS, that option didn't exist. Will look at the gateway and select commands next. bernie karmel Troy Sosamon wrote: >Bernie, > >Personally, I would upgrade to 6.5++ for DOS first and then convert to the >Windows platform. That way you are not having to make 2 conversions at >once. The upgrade to 6.5++ DOS will be pritty easy. > >As far as importing and exporting fixed field files, there should be no >problem doing this. >Take a look at the load command to import your files, and to export them, >you can use unload, gateway, or select to get a fixed field file. > >How are you doing it now? > >Troy Sosamon > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of BKarmel >Sent: Saturday, June 28, 2003 1:34 PM >To: RBASE-L Mailing List >Subject: [RBASE-L] - Re: Export of ASCII Fixed file of table data > > >I have just begun the task of switching over from my very stable Rbase >4.5++ data bases to the Windows version of RB2000 (6.5++). This might >be trivial, but I do not see that I can import or export an ASCII fixed >file as I am able to do in the DOS 6.5 version. I have a great number of >applications that expect a .FIX file structure as input. Is there any >way I can use the Windows version for ASCII fixed files? > >bernie karmel > > > >
