Text Importer

[ScottMattes]

Has anyone noticed a problem with loading text? I was trying to load a text file into one column of a staging table yesterday. The file has 633 lines in it, but TI only loaded 501. When I went to find that last line it was actually line 530 in the file - so not only were the last 132 lines missing, but so were 29 prior lines.

I can't share the file, but I can describe it. The lines are 327 characters long, all ending with spaces. I defined the load to first put the line into the table field, then I defined bogus fields and used seq.nextval for one, sysdate for the other.

I haven't played with it to determine if there was a work around, so I just fell back to Excel and created the SQL inserts by hand.

 

[Marco Kalter]

I know you said you can't share it, but is it possible to send me the file? Or a similar file that reproduces this issue?

 

[ScottMattes]

Marco,
I'll try to make a file that gives the same results and send it.

 

[ScottMattes]

Marco,
While trying to create a file to illustrate the problem that I could send you I found the problem.

There were some lines with " in them, and the default quote character is ". Switching to ' allowed the whole file to load.

I would like to have no quote character as one of the choices. I wasn't loading a CSV file, just straight text.

Thank you.