How to Strip Quotation Marks from an ASCII Delimited Text FileID: Q143245
The information in this article applies to:
SUMMARYTypical methods of generating ASCII text files place double quotation marks around character fields. Sometimes these quotation marks aren't wanted. This article presents a way to remove the quotation marks programmatically. If there are double quotation marks embedded in the data itself, however, this method cannot be used.
MORE INFORMATIONTo remove quotation marks from an ASCII text file programmatically, you must first place the file in a memo field. Then the STRTRAN() function can be used to replace each instance of double quotations with a blank space. The corrected contents of the memo field can then be copied to an ASCII text file. To demonstrate this technique, type and run the following program named Myprog.prg.
Using any text editor, open Mytext.txt and observe the double quotation
marks around the character fields. Then open Quoteles.txt to confirm that
the quotation marks have been removed.
Additional reference words: 2.60a 3.00 3.00b FoxWin FoxDos FoxMac VFoxWin quotes KBCategory: kbhowto KBSubcategory: FxprgTable
|
Last Reviewed: May 22, 1998 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |