Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread 3.30 - ImportTable not handling strings in quotes that contain commas
Tue, Jul 18 2006 6:30 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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. Smiley

--
Tim Young
Elevate Software
www.elevatesoft.com

Image