load data
infile 'Rank.dat'
replace
into table rank
fields terminated by '|' optionally enclosed by '€'
(rankid, rankabbrev, rank, description, BfNAbbrev)