Skip to Content
Former Member
Aug 01, 2009 at 09:32 AM

End of file character in flat file



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)?