home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,092 of 9,834   
   JoeSpareBedroom to All   
   Pdox DOS import problem   
   06 Mar 08 15:45:18   
   
   From: dishborealis@yahoo.com   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca