Re: Import CSV file with '?' as null representation
A good text editor can do that replacement in one step.
If it's just one column involved, and if the question marks are quoted, you can write the Load Data Infile statement to assign the column to a user variable, then to the Load Data command add something like ...
set column_name=if(@myvar='?',null,@myvar)
Subject
Written By
Posted
Re: Import CSV file with '?' as null representation
January 19, 2015 06:20PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.