Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing .TXT files to tab or comma delimited

Status
Not open for further replies.

netto

Technical User
May 23, 2001
1
US
How do I convert a .txt file (created in FoxPro) to tab or comma delimited format?
 
You'll need to ensure that there is a character or sequence of some sort that can be used as a delimiter. A simple find/replace will work for character replacement (e.g. replace all occurances of three spaces with tab).

Word and Excel could be great tools for doing this, depending upon what you're trying to do. Excel may be your best choice since it has a wizard to help you parse text files (open text file in Excel and from the menu choose Data then Text to Columns). Word would be better if you need to replace characters with other characters. Remember that a tab is represented as ^t in Word.
 
You might try a file conversion utility called DBMS/Copy, from Conceptual Software, which you can find on the Web at It handles many file formats, including many varieties of ASCII files.

Predictor
 
if you have access to foxpro and the original dbf file
you can
use filename
copy to <filename> type delimited && &quot;xxx&quot;,&quot;xxx&quot; format
copy to <filename> type delimited tab && tab delimited

if you dont you can
create a dbf and
append from <file.txt>type sdf
then do above.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top