Hello
I use the command

IMPORT TABLE TempImport FROM WorkFile IN STORE MyStore DELIMITER CHAR '|'

but also the commas " behave as delimiter?

Thanks Sorin

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

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

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

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

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