csv files and memo fields

2007-01-31 Thread Judith Barer
Does anybody have an idea how I could generate a csv file programtically that would include in it the info from memo fields. What would be the simplest way to do this? I also would like to take a csv file and append it to a dbf file with memo fields. I tried converting the file to a string

Re: csv files and memo fields

2007-01-31 Thread Alan Bourke
Judith Barer wrote: Does anybody have an idea how I could generate a csv file programtically that would include in it the info from memo fields. What would be the simplest way to do this? Personally I always use textmerge to create files like this. set textmerge on noshow set textmerge

Re: csv files and memo fields

2007-01-31 Thread Peter Cushing
Judith Barer wrote: Does anybody have an idea how I could generate a csv file programtically that would include in it the info from memo fields. What would be the simplest way to do this? I also would like to take a csv file and append it to a dbf file with memo fields. I tried converting

RE: csv files and memo fields

2007-01-31 Thread Judith Barer
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Cushing Sent: Wednesday, January 31, 2007 11:37 AM To: [EMAIL PROTECTED] Subject: Re: csv files and memo fields Judith Barer wrote: Does anybody have an idea how I could generate a csv file

Re: csv files and memo fields

2007-01-31 Thread Vince Teachout
Judith Barer wrote: I need to account for the field being bigger than 250 chars Then you pretty much have to write code to generate the text output yourself. :-( Be careful of embedded line breaks, soft returns, and delimiters within your memo field!

Re: csv files and memo fields

2007-01-31 Thread Vince Teachout
Judith Barer wrote: I also would like to take a csv file and append it to a dbf file with memo fields. I tried converting the file to a string using strtofile and then using a alines but the file is so big that it generates a subscript out of range error. I am using VFP 8.0. I'm just

RE: csv files and memo fields

2007-01-31 Thread Fletcher Johnson
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Judith Barer Sent: Wednesday, January 31, 2007 8:21 AM To: profox@leafe.com Subject: csv files and memo fields Does anybody have an idea how I could generate a csv file programtically that would include in it the info from memo fields

RE: csv files and memo fields

2007-01-31 Thread Judith Barer
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Wednesday, January 31, 2007 11:55 AM To: [EMAIL PROTECTED] Subject: Re: csv files and memo fields Judith Barer wrote: I also would like to take a csv file and append it to a dbf file

Re: csv files and memo fields

2007-01-31 Thread Vince Teachout
Judith Barer wrote: I am not taking one dbf file and transferring it to another. What I am doing is sharing data. I work for a kosher certifying agency and what I am doing is sharing data with other certifying agencies so I am supposed to create csv files of our data and download csv files

Re: csv files and memo fields

2007-01-31 Thread MB Software Solutions
Judith Barer wrote: snipped There are definitely better ways to approach this issue such as using web services and such but we are not doing that. Why not? We had agreed to use XML files which worked fine but the files are quite large. So some agencies requested to use csv instead. For

RE: csv files and memo fields

2007-01-31 Thread mrgmhale
, 2007 3:49 PM To: [EMAIL PROTECTED] Subject: Re: csv files and memo fields Judith Barer wrote: snipped There are definitely better ways to approach this issue such as using web services and such but we are not doing that. Why not? We had agreed to use XML files which worked fine

RE: csv files and memo fields

2007-01-31 Thread Virgil Bierschwale
] [mailto:[EMAIL PROTECTED] On Behalf Of Judith Barer Sent: Wednesday, January 31, 2007 11:00 AM To: profox@leafe.com Subject: RE: csv files and memo fields -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Wednesday, January 31, 2007 11:55 AM