Appending from Comma Delimited file into MEMO field

[csr]

I am appending data from a comma delimited file and everything works fine except for the fact that one of the fields contains more than 254 characters (the limit for a text field). So, I tried changing the field in the target file to a memo field. Now, nothing comes in to that field.
Is that as it should be (by design) or could I be doing some thing wrong here ?


Don

 

[TamarGranor]

Yes, it's by design. APPEND FROM ignores memo fields.

Tamar

 

[pthalacker]

From the help file on APPEND FROM

You cannot append to memo fields from text files such as CSV and SDF files.

You might be able to parse it using

Alines(FileToStr(myfile.txt))

or you may have to resort to using low-level file functions

pamela

 

[TheRambler]

You might want to read this article:
How To Append Records from Any Delimited File with Memo Data

I didn't try it, but it says:

Character strings with a length in excess of 10,000 characters have been tested and work fine when imported into a memo field.

Good luck.

 

[csr]

Tamar: Thanks for the confirmation of bad news.

TheRambler: I read the article. Tried the software. It is flawed. It does not respect the field delimiters (commas)and processes commas within quotes as field delimiters. I will take a look at it to see if I can discern why it does that but it is somewhat complicated and I may not be able to figure it out.



Don

 

[csr]

Don here again ...

I mis-spoke on my previous post. I should have said ... It does not respect the STRING DELIMITERS. It processes commas imbedded within a STRING as field delimiters.

Don

 

[TheRambler]

Here's another article that takes care of embedded commas:

How to Read Memo Field Data from Delimited ASCII Files

Hope it helps.