bannon@andromeda.rutgers.edu (Ron Bannon) (05/27/91)
I'd like to upload some dBase files from an IBM XT to a UNIX system and then convert them into tab delimited ASCII files. I have no knowledge of dBase and need advice on the best way to accomplish this task. If all else fails I will download the dBase files from the UNIX system to my MAC for translation, the MAC has a translator program that will do the conversion. I would greatly appreciate any help or advice. Thanks, Ron Bannon bannon@andromeda.rutgers.edu bannon@math.rutgers.edu
smith@muvms3.bitnet (Phil smith) (05/28/91)
In article <May.26.18.45.39.1991.21855@galaxy.rutgers.edu>, bannon@andromeda.rutgers.edu (Ron Bannon) writes: > I'd like to upload some dBase files from an IBM XT to a UNIX system and then > convert them into tab delimited ASCII files. I have no knowledge of dBase > and need advice on the best way to accomplish this task. If all else fails > I will download the dBase files from the UNIX system to my MAC for > translation, the MAC has a translator program that will do the conversion. > > I would greatly appreciate any help or advice. > > Thanks, > Ron Bannon > bannon@andromeda.rutgers.edu > bannon@math.rutgers.edu -- Ron, Dbase has an option to the 'Copy' command that allows you to create delimited files. I am not sure extactly how you would specify a tab but the command is: Copy to {filename} delimited with {delimiter} note: 1: {} are mine 2: be sure to supply an extension to the newly created file. Hope this helps. Phil ------------------------------------------------------------------------- Phil Smith BITNET: Smith@Marshall Senior Systems Analyst Internet: Smith@Marshall.edu Marshall University Smith@Muvms3.wvnet.edu University Computer Center Phone/voice: (304) 696-2591 Prichard Hall FAX: (304) 696-3601 Huntington, WV 25755-5320 ------------------------------------------------------------------------- Opinions? My employer doesn't allow me to have any - these are borrowed.
FelineGrace@cup.portal.com (Dana B Bourgeois) (05/30/91)
"need help in exporting dbase III files to tab delimited form"
In dbase III+ you can export a data file by using the Copy command:
COPY TO <valid file name> DELIMITED
This will result in 1 line per record. Each line will end in a CR/LF
pair. Each field in the record will have a comma delimiting it and
all strings will be surrounded with double quotes.
COPY TO <valid file name> DELIMITED WITH <ascii char>
changes the delimiter character from double quotes to <ascii char>. The
field separater character remains the same.
COPY TO <valid file name> DELIMITED WITH BLANK
changes both the field separater character and the delimiter character
to the space character.
Using one of these commands you should be able to convert the data file
into a convenient form (perhaps standard 'delimited'), transfer it to
the Unix box and in emacs do a search and replace to replace field
separaters with tab characters and string delimiters with spaces.
Dana Bourgeois @ cup.portal.com