LOAD DATA INFILE doesn't support escaped escape sequences

create a table that contains a backslash value ( \ )
export that table with SELECT INTO OUTFILE, which uses a default escape character of \
examine the output file and you will find the value is represented as \ \ ( no spaces between them but JIRA won't display backslash backslash,which is an escaped escape sequence)
attempt to load this data with LOAD DATA INFILE (piping to cpimport internally) and you will get a "too many columns" error

This is the problem data from my table created with
select * from tabledata into outfile '/path/to/file.txt' fields terminated by '|' enclosed by '"';

{{"81415278"|"tahxxx@gmail.com"|"tahxxx@gmail.com"|"tamxxx"|"Huff\ \"|"2"|"5477"|"440"|"6"|"37"|"1"|"6855"|""|"2016-12-18 07:50:30"|"2016-12-18 03:37:29"|""

I removed the "backslash backslash" from the flat file and I was able to load the table successfully using LOAD DATA INFILE.}}