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
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.