Joe Yoder wrote on 2012-02-10:
> 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
>
Joe,
Using LLFF
process each line with FGETS()
loop through the characters backward, if you find a quotation mark
before a comma,
you're not at the end
append the next line from the file
write each line out to a new file as you process the
I thought about using a regular expression, they only work on a line by line
bases too.
Tracy Pearson
PowerChurch Software
_______________________________________________
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.
