"JoeSpareBedroom" <dishborealis@[EMAIL PROTECTED]
> wrote in message
news:ikUzj.5632$7d1.5290@[EMAIL PROTECTED]
> I've got a txt file with fields delimited by commas. One field contains
> product descriptions, and many have words enclosed in quotation marks.
> When using Tools, Im****t, Ascii, Delimited, Pdox has problems with
records
> containing those quotation mark-affected words. So, the im****t never
> proceeds. I could do a search-replace on the txt file and remove all the
> quotation marks, but that presents another problem: Some descriptions
also
> contain stuff like
>
> paper plates 10"
>
> ...where that 10 inch designation is im****tant, so I don't want to
remove
> ALL quotation marks.
>
> How do I tell Pdox to ignore quotation marks completely during the
im****t,
> and focus only on the commas? I seem to recall a way of adjusting im****t
> parameters, but it's been too long since I did this. I see nothing in
the
> menus.
>
OK - found the options screen (CUSTOM). Shows string delimiter as a
quotation mark. Won't accept a blank value, and changing it to a comma has
no effect on the situation.


|