Software that shows "true" row terminator in data file
I'm working with an application called Office Tracker that spits out pipe-delimited calendar data files on 15-minute increments. I'm struggling to import the files using the SQL Server BCP utility. I'm 95% sure it's the row-delimiters in the data files that are giving me trouble. If I open one of the files using Notepad, the row delimiter looks like thick rectangle. (I show this in the attached document.) Is there some application out there that shows me what this row delimiter truly is? Or maybe I already have the application (Wordpad, Word, Notepad...) and I just don't know how to use it. Row-Delimiter.jpg
Microsoft ApplicationsMicrosoft SQL ServerMySQL Server