Thanks guys for all the replies. I just did some analysis and found that the end of record CRLF and the end of line CRLF within a quoted field are identical. The replacements need to happen only inside quotes. Initially I thought I could preprocess the file to changed the eol combinations to a different character pair, import, and then convert back to CRLF pairs. I now realize that the formatted data with embedded CRLFs will probably not work with edit and browse functions and maybe nowhere in Foxpro. It looks like I will need to do my own low level routine and use memo fields where embedded CRLF pairs are needed.
I just checked the contact manager in Google Apps and there are only 3 export formats listed: Google CSV, Outlook CSV, and Vcard format. When I compare the two CSV exports a lot of the field names are different and the Outlook one has about 30 more fields. I assume the Google format is the actual file layout and the Outlook one includes all the fields that Outlook supports even though Google does not. If anyone know different - I'd like to know. The goal of this exercise is to bring contact information from Foxpro to Smart phones via Google Apps. Thanks again - Joe On Friday, February 10, 2012 8:49 AM, Alan Bourke wrote: > >Date: Fri, 10 Feb 2012 13:49:26 +0000 >From: Alan Bourke >To: [email protected] >cc: >Subject: Re: Appending from a CSV file with CR embedded in fields > >It *is* working as designed, the help says: > >"Specifies that the source file from which data is appended to the >current Visual FoxPro table is a delimited file. A delimited file is an >ASCII text file in which each record ends with a carriage return and >line feed. " > >So I would read the whole file into a string (assuming it's not vast), >STRTRAN() the carriage returns to a pipe character or something, write >the string to a temp file, APPEND FROM the temp file, delete the temp >file. > >-- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
