Importing text into memo fields. Can it be done? 
Author Message
 Importing text into memo fields. Can it be done?
Has anyone had any luck in identifying a way to import large chunks of
text into a memo field.  I have about 1500 records that are basically
ascii, delimited only by carriage returns (or alternatively a delimiter
such as "&&") that I want to import into a paradox table...each record
being put into a memo field. Each record (memo) is equivalent to about
a page of text.   Any ideas???  HELP!!


Sun, 30 Nov 1997 03:00:00 GMT
 Importing text into memo fields. Can it be done?


Quote:
(Jerome Smith) writes:
>Has anyone had any luck in identifying a way to import large chunks of
>text into a memo field.  I have about 1500 records that are basically
>ascii, delimited only by carriage returns (or alternatively a delimiter
>such as "&&") that I want to import into a paradox table...each record
>being put into a memo field. Each record (memo) is equivalent to about
>a page of text.   Any ideas???  HELP!!

If you can get the file to have consistent delimiters, then you can write
an ObjectPal script to read in the file and output to a memo field.

Use TextStream type methods to read in the file, character by character or
line by line, searching for the && marker. Each time you find one, you can
take the String you've been building up, cast it as a memo type
memo(StringVar), and write it to a new record in a TCursor.

-Greg Neumarke



Tue, 09 Dec 1997 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How to import ASCII text into memo field ?

2. Importing text into memo field

3. HELP! - importing text to memo fields

4. Importing (large amnts) text into memo fields

5. Import of long text(delimited) to PFW5.0 memo fields

6. Importing long text data to PFW 5.0 memo field

7. Importing text into memo fields?

8. Re : FPM 2.6 : How to import text files into memo fields

9. Text import to Paradox 4 memo field - how?

10. Field Validation - What am I doing wrong ?

11. Converting VFP memo fields to SQL Server text fields

12. PROBLEMS INSERTING MEMO FIELDS FROM TABLE FIELD TO TEXT FILE


 
Powered by phpBB® Forum Software