yet question!
log:
Record 713: Rejected - Error on table UG_HISTORY, column TXTFILE.
second enclosure string not present
ctl file:
LOAD DATA

INFILE 'UG_HISTORY.dat'

INTO TABLE UG_HISTORY
APPEND fields TERMINATED BY "#" optionally ENCLOSED BY '№' TRAILING NULLCOLS
(
ID
TXTFILE CHAR(4000),
UPDATEDT timestamp 'YYYY-MM-DD HH24:MI:SS.ff',
)

bad file:
№7702№#№Toru and Naoko's college romance
might have been perfectly simple and predictable.
They might have been confronted
with
the ordinary issues of becoming
young adults in a large foreign city.
---------
but farther there must be a date, but SQL loader breaks((
alike from after transition on new line...
how to avoid it?