Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread ImportTable, Pipe-delimited
Tue, Jan 5 2021 7:44 PMPermanent Link

AlanL

Hi,
I am getting an error message when importing a pipe-delimited text file.
The error message is:-
DBISAM Engine Error # 11309 An error occurred during the
import into the table 'DF134' - Expected ' but instead found
'ANNAVERE MANOR" #6 NEILS|ST MICHAEL|BB in import data.

The complete line is:
510170|GREG CLARKE|'ANNAVERE MANOR" #6 NEILS|ST MICHAEL|||||CA

I've noticed that this occurs when there is one apostrophe in the text immediately after the pipe-delimited character.
The text file is large and there are many instances similar to example line above.
I am using DBISAM ImportTable method. DBISAM Version 4.49, Build1, Delphi7 Pro

regards,
Alan
Wed, Jan 6 2021 2:44 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

AlanL


Since I don't have DBISAM source I'm guessing. I think the problem is the double quote not the single quote. The csv format (ok you're using pipe not comma) is notoriously lax but you'd normally expect to see double quotes in pairs - at the start and end of a field.

Roy Lambert
Wed, Jan 6 2021 3:58 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

AlanL


I was interrupted - to finish off it looks as though you have a text field which has a single quote at the start and a double quote part way through  - that's going to give any parser a bit of a headache.

I'd recommend having a word with whoever is producing the pipe-delimited text file


Roy Lambert
Wed, Jan 6 2021 1:59 PMPermanent Link

Raul

Team Elevate Team Elevate

On 1/6/2021 3:58 AM, Roy Lambert wrote:
> I was interrupted - to finish off it looks as though you have a text field which has a single quote at the start and a double quote part way through  - that's going to give any parser a bit of a headache.
>
> I'd recommend having a word with whoever is producing the pipe-delimited text file

This IMHO is the core issue - in order to be able to include delims in
field values there is text start/end indicator (usually quote)

Original message today is this in terms of one field per line

510170
GREG CLARKE
'ANNAVERE MANOR" #6 NEILS|ST MICHAEL|||||CA


and is not terminated

Raul
Wed, Jan 6 2021 4:28 PMPermanent Link

AlanL


AlanL wrote:

Hi,
I am getting an error message when importing a pipe-delimited text file.
The error message is:-
DBISAM Engine Error # 11309 An error occurred during the
import into the table 'DF134' - Expected ' but instead found
'ANNAVERE MANOR" #6 NEILS|ST MICHAEL|BB in import data.

The complete line is:
510170|GREG CLARKE|'ANNAVERE MANOR" #6 NEILS|ST MICHAEL|||||CA

I've noticed that this occurs when there is one apostrophe in the text immediately after the pipe-delimited character.
The text file is large and there are many instances similar to example line above.
I am using DBISAM ImportTable method. DBISAM Version 4.49, Build1, Delphi7 Pro

regards,
Alan


Hi,
Thanks everyone for your help. I will ask the user to avoid placing an apostrophe at beginning of the text, or if they do then place another apostrophe as a terminator at the end of the text.

regards,
Alan
Image