Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 5 of 5 total |
ImportTable, Pipe-delimited |
Tue, Jan 5 2021 7:44 PM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 PM | Permanent Link |
Raul 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 PM | Permanent 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 |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |