Importing from DEL file where a column value begins with a " ?

[PaulR]

Hi,

We seem to have encountered a bug(or working as deigned?) in the import
utility on 8.2 LUW.

We are using the standard column and char delimiters of , and " while
loading files of type DEL.

our extract programs which produce the del files, implement a rule
which states if a varchar column contains a " output this as ""

All works fine, so long as the " doesn't appear as the very FIRST
character

i.e
1,"""this is the string""",

Fails to import.

Is this a bug? or am I reading the statement in the docs. wrong?
quote:
' Any pair of character delimiters found between the enclosing
character delimiters is imported or loaded into the database'

Thanks.

Paul.

[Ian]

PaulR wrote:

Hi,

We seem to have encountered a bug(or working as deigned?) in the import
utility on 8.2 LUW.

We are using the standard column and char delimiters of , and " while
loading files of type DEL.

our extract programs which produce the del files, implement a rule
which states if a varchar column contains a " output this as ""

All works fine, so long as the " doesn't appear as the very FIRST
character

i.e
1,"""this is the string""",

Fails to import.

Is this a bug? or am I reading the statement in the docs. wrong?
quote:
' Any pair of character delimiters found between the enclosing
character delimiters is imported or loaded into the database'

Working as designed. The character delimiter (default = ") should
always appear around a character column's data. Furthermore, if
the column's value contains the character delimiter, it will be
doubled.

"""this is the string"""
^ ^ = character delimiters
^^ ^^ = escaped characters within the field
Another example:

1,"this ""is the"" string"

Will import as

C1 C2
---------- --------------------
1 this "is the" string

[Ian]

Ian wrote:

PaulR wrote:

Hi,

We seem to have encountered a bug(or working as deigned?) in the import
utility on 8.2 LUW.

We are using the standard column and char delimiters of , and " while
loading files of type DEL.

our extract programs which produce the del files, implement a rule
which states if a varchar column contains a " output this as ""

All works fine, so long as the " doesn't appear as the very FIRST
character

i.e
1,"""this is the string""",

Fails to import.

Is this a bug? or am I reading the statement in the docs. wrong?
quote:
' Any pair of character delimiters found between the enclosing
character delimiters is imported or loaded into the database'

Oops. Ignore my previous post, I was misreading your post. Are you
saying that the construct you have above fails when you try to import
it?

What's your import statement, table DDL and the error code?