By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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?

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.