February 6, 2008 at 9:18 am
I've trying to import data from a tab delimited file from an old informix database.
standcodestanddescrelement1max01min01
"ASTM A182,F316L"STAINLESS STEEL FORGINGSC0.035
ASTM A105NCARBON STEELC0.349999994
"ASTM B150,UNSC63200"ALUMINIMUM BRONZE ROD & BARAl9.58.699999809
"ASTM B151,UNSC71500""CUPRO NICKEL 70/30 ROD & BAR (OVER 1"")"Cu65
The 4th record is causing me a problem, it's both " text indentified and has "" in it to represent 1". Any idea how this little problem can be gotten around without changing the file format too much as I don't have control over that 🙁
The error I get is...
[Flat File Source [4963]] Error: The column delimiter for column "standdescr" was not found.
February 6, 2008 at 9:39 am
I would forgo telling the import that it might have quoted text delimiters, and deal with them after the import.
You should be able to remove the leading and ending quotes using a simple update once the data is in the staging table.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply