sqlldr will handle this for you - it looks like you're using Oracle.
Code:
OPTIONS (DIRECT=false)
LOAD DATA
INFILE 'myfile'
APPEND
INTO TABLE MYTABLE
FIELDS TERMINATED BY '~'
TRAILING NULLCOLS
(FLD1, FLD2, FLD3)
a ctl file like this one will do what you show.
