Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
3.30 - ImportTable not handling strings in quotes that contain commas |
Tue, Jul 18 2006 6:30 PM | Permanent Link |
Michael Fullerton | DBISAM 3.30
If I import a text file using ImportTable where the records are comma separated but there are string fields that contain commas the import will not work correctly. The field containing commas will be split up instead of being treated as a single value. For example if I have: "Mo,Fr","PShore" On import the table will have Mo |Fr Not Mo,Fr |PShore ___ Free Project Time Tracker for Delphi Developers http://www.cybermatrix.com/pcdelphi.html |
Wed, Jul 19 2006 7:57 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< If I import a text file using ImportTable where the records are comma separated but there are string fields that contain commas the import will not work correctly. The field containing commas will be split up instead of being treated as a single value. >> I just tried it with the 3.30 DBSYS, and it seems to work fine here. Could you email me the import file that you're using ? -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Jul 20 2006 12:46 PM | Permanent Link |
Michael Fullerton | On Wed, 19 Jul 2006 19:57:39 -0400, "Tim Young [Elevate Software]"
<timyoung@elevatesoft.com> wrote: >Michael, > ><< If I import a text file using ImportTable where the records are comma >separated but there are string fields that contain commas the import will >not work correctly. The field containing commas will be split up instead of >being treated as a single value. >> > >I just tried it with the 3.30 DBSYS, and it seems to work fine here. Could >you email me the import file that you're using ? Yes, you're right. I forgot there was a secondary file involved in the import wizard that was not formatted properly. Very sorry to waste your time. Let me know if you want to see the DBISAM/CSV import wizard code, it might be something you could incorporate in DBSys. ___ Free Project Time Tracker for Delphi Developers http://www.cybermatrix.com/pcdelphi.html |
Thu, Jul 20 2006 8:07 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< Yes, you're right. I forgot there was a secondary file involved in the import wizard that was not formatted properly. Very sorry to waste your time. Let me know if you want to see the DBISAM/CSV import wizard code, it might be something you could incorporate in DBSys. >> Sure, I'm always interested in free code. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |