From: dishborealis@yahoo.com   
      
   "JoeSpareBedroom" wrote in message   
   news:ikUzj.5632$7d1.5290@news01.roc.ny...   
   > 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, Import, Ascii, Delimited, Pdox has problems with records   
   > containing those quotation mark-affected words. So, the import 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 important, so I don't want to remove   
   > ALL quotation marks.   
   >   
   > How do I tell Pdox to ignore quotation marks completely during the import,   
   > and focus only on the commas? I seem to recall a way of adjusting import   
   > 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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|