We are loading data into BI via a flat file (~ separated .txt). This file is created by a different system. A special character is inserted by the system as the end of file character while creating the flat file. When we are loading the file in BI, the data load fails due to this character. Is there some way we can skip reading this character (something like ignore last row)?