"Steve Kass" <skass@drew.edu> wrote in message
news:Oe1kAg7aEHA.2520@TK2MSFTNGP12.phx.gbl...
> Carol,
>
> My top two suggestions are
> 1. Ask for better data, which uses a character not in the text to
> delimit (perhaps | or tab?), or try to preprocess the text using
> something like the Unix utilites available for Windows in Cygwin.
> Someone who can write awk, sed, or perl scripts can probably do
> something about this, if there are no ambiguities that can't be resolved
> due to both commas and " marks in the quoted parts.
>
> Steve Kass
> Drew University
>
>
>
> Carol wrote:
>
> >Hiya,
> >
> >What can i do when my import fails because some of the fields in my my
> >comma-delimited text file
> >have quotation marks?
> >
> >scample =
> >
> >"howdy doody", 43334443, " Mary's "handy man "
> >
> >
> >Thanks!
> >
> >
> >
> >

Carol wrote:

>Hiya,
>
>What can i do when my import fails because some of the fields in my my
>comma-delimited text file
>have quotation marks?
>
>scample =
>
>"howdy doody", 43334443, " Mary's "handy man "
>
>
>Thanks!
>
>
>