Subject | Problem (bug?) in TIB_Import |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2002-09-23T10:05:25Z |
IBO 4.2Hc, BC++ 5
Hi!
I have table with 3 fields (VARCHAR(9), VARCHAR(15), INTEGER).
I noticed, that when I try to import file where rows look like that:
"73000", "10000000036", "1"
"73000", "10000000052", "1"
"73000", "10000088634", "1"
"73000", "10000103454", "1"
The middle field will contain also the space, i.e instead of "10000103454" I will get " 10000103454".
I know that the field separator is comma, but if the fields are also contained between " ", shouldn't only inside of it be read in?
Riho-Rene Ellermaa
senior programmer
Hansabank
Hi!
I have table with 3 fields (VARCHAR(9), VARCHAR(15), INTEGER).
I noticed, that when I try to import file where rows look like that:
"73000", "10000000036", "1"
"73000", "10000000052", "1"
"73000", "10000088634", "1"
"73000", "10000103454", "1"
The middle field will contain also the space, i.e instead of "10000103454" I will get " 10000103454".
I know that the field separator is comma, but if the fields are also contained between " ", shouldn't only inside of it be read in?
Riho-Rene Ellermaa
senior programmer
Hansabank