HOW TO EXPORT TEXT FROM MEMO-FIELDS TO ASCII FORMAT 
Author Message
 HOW TO EXPORT TEXT FROM MEMO-FIELDS TO ASCII FORMAT
How can i export text in memo-fields to ASCII format. What are the easy ways
to convert text in memo-fields to ASCII text or other word
processing formats (.DOC; .TXT etc). Another issue is how to export to
Delimited text format, wich is the format i need. I also welcome any other
suggestion about other ways to export text in memo-fields, wich eventually
results in a delimited text format.  

Thanks!!

Erlend Bullvaag
Bodoe Graduate School of Business
Norway



Fri, 28 Feb 1997 18:53:15 GMT
 HOW TO EXPORT TEXT FROM MEMO-FIELDS TO ASCII FORMAT

Quote:

> How can i export text in memo-fields to ASCII format. What are the easy ways
> to convert text in memo-fields to ASCII text or other word
> processing formats (.DOC; .TXT etc). Another issue is how to export to
> Delimited text format, wich is the format i need. I also welcome any other
> suggestion about other ways to export text in memo-fields, wich eventually
> results in a delimited text format.  

> Thanks!!

> Erlend Bullvaag
> Bodoe Graduate School of Business
> Norway

Erlend,

I had the same problem and beat my head against the wall for quite a while
before I finally figured it out.  

Happy Computing!

Emily

; This pushbutton method reads the fields in dbfile.db
; and dumps them out to a delimeted ascii text file.
;
; The fields are enclosed in double quotes and
; delimeted by a comma. The record ends with a newline.
;
; There are 7 fields in the dbfile.db record.  
;
; I have used this with memo and formatted memo fields.
;
; You can format your data anyway you want.
; To change the delimeters, you simply
; replacing the quoted commas with your own delimeter.
; If you don't want the text enclosed in double quotes,
; remove them from the code.

method pushButton(var eventInfo Event)
var
        export_array    Array[7] AnyType
        tc              TCursor
        ts              TextStream
        i               SmallInt

endVar

        tc.open("dbfile.db")
        ts.create("asciifl.txt")

        while tc.eot() = False

                tc.copyToArray(export_array)

                for i from 1 to 6
                        ts.writeString("\"",export_array[i],"\"",",")
                endFor

                ts.writeString("\"",export_array[7],"\"","\n")

                tc.nextRecord()

        endWhile

        tc.close()
        ts.close()

endmethod



Sun, 02 Mar 1997 18:25:37 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Exporting formatted Memo fields in a text file

2. Export Formatted Memo Fields with formats

3. Exporting Pdox memo fields to ascii - Pdox for Win 4.5

4. Exporting dBASE IV memo field to ASCII file without using dbase IV

5. Export information into ASCII Text Format

6. How to import ASCII text into memo field ?

7. Exporting of Formatted Memo Fields into Excel

8. Formatted Memo Field & Exporting to Tab Delimited

9. Copying text into formatted memo fields

10. Exporting Memo field data to a text file

11. Exporting Memo field data to a text file


 
Powered by phpBB® Forum Software