I have come across this too.
One option might be to pick up the string, use ReplaceAll
to replace all occurrences of "," with a tab ie chr(9). Then import it into
your table or what ever using NthField.
Or just use tab separated format as your go between if possible
Barney
> I am using the OpenCSVCursor function. It works fine, except it seems to
> not allow commas at all within text fields, even if the text fields are
> enclosed in double quotes. Is there a way to escape commas in CSV
> content?
>
> Alex Rice, Software Developer
> Architectural Research Consultants, Inc.
> alex_rice at arc dot to
> alrice at swcp dot com
>
>
>
> ---
> Subscribe to the digest:
> <mailto:realbasic-nug-digest at lists dot realsoftware dot com>
> Unsubscribe:
> <mailto:realbasic-nug-off at lists dot realsoftware dot com>
|