Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
IMPORT TABLE error |
Tue, Jul 15 2014 6:20 AM | Permanent Link |
Hershcu Sorin | Hello
I use the command IMPORT TABLE TempImport FROM WorkFile IN STORE MyStore DELIMITER CHAR '|' but also the commas " behave as delimiter? Thanks Sorin |
Tue, Jul 15 2014 7:25 AM | Permanent Link |
Malcolm Taylor | Sorin Hershcu wrote:
> Hello > I use the command > > IMPORT TABLE TempImport FROM WorkFile IN STORE MyStore DELIMITER CHAR > '|' > > but also the commas " behave as delimiter? > > Thanks Sorin The '' you mention are not commas, they are quote chars. If you do not quote text, you can use QUOTE CHAR #0 |
Tue, Jul 15 2014 7:27 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Sorin
>I use the command > >IMPORT TABLE TempImport FROM WorkFile IN STORE MyStore DELIMITER CHAR '|' > >but also the commas " behave as delimiter? I'm not 100% certain what you're actually saying or asking here but as a guess try replacing '|' with #nnn where nnn is the ascii value of | Roy Lambert |
Wed, Jul 16 2014 3:09 AM | Permanent Link |
Hershcu Sorin | Thanks
I actually use number #124. Still if on the imported file appear the char " it's raise an error. Sorin þþý"Roy Lambert" ýþ ëúá áäåãòä news:C0F168D3-7C98-4618-A629-CC0B85F849CD@news.elevatesoft.com... Sorin >I use the command > >IMPORT TABLE TempImport FROM WorkFile IN STORE MyStore DELIMITER CHAR '|' > >but also the commas " behave as delimiter? I'm not 100% certain what you're actually saying or asking here but as a guess try replacing '|' with #nnn where nnn is the ascii value of | Roy Lambert |
Wed, Jul 16 2014 4:06 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Sorin
>I actually use number #124. >Still if on the imported file appear the char " it's raise an error. To restate a bit - if the import encounters a double quote (#34) not two single quotes (#39#39) then you have an error. This is almost certainly a data problem. Does the file you're trying to import use #34 rather than #39 as a delimiter for strings? If so have a look at the QUOTE CHAR clause for IMPORT TABLE. If that's not the problem can you post the exact import statement you're using and a sample of the data that's causing the error. Roy Lambert |
Wed, Jul 16 2014 12:52 PM | Permanent Link |
Hershcu Sorin | Thanks Roy
The imported file include double quote (#34) on the data but not as delimiter. I'll try the QUOTE CHAR option. Thanks Sorin þþý"Roy Lambert" ýþ ëúá áäåãòä news:DC1D5F2A-7D50-4E64-973C-B12A50B55EE5@news.elevatesoft.com... Sorin >I actually use number #124. >Still if on the imported file appear the char " it's raise an error. To restate a bit - if the import encounters a double quote (#34) not two single quotes (#39#39) then you have an error. This is almost certainly a data problem. Does the file you're trying to import use #34 rather than #39 as a delimiter for strings? If so have a look at the QUOTE CHAR clause for IMPORT TABLE. If that's not the problem can you post the exact import statement you're using and a sample of the data that's causing the error. Roy Lambert |
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 |