I was loading data using anaplan connect and i got an error saying there was a tab in my data.
Turns out anaplan connect Anaplan Connect cannot allow tabs in TEXT fields. This is rooted in how Anaplan Connect constructs the information from JDBC to be passed into Anaplan.
I got around this in the sql by using the following syntax in my sql statement:
REPLACE(REPLACE(REPLACE(fieldname, CHR(10)), CHR(13)), CHR(9))