troubleshooting Question

Software that shows "true" row terminator in data file

Avatar of jdana
jdanaFlag for United States of America asked on
Microsoft ApplicationsMicrosoft SQL ServerMySQL Server
3 Comments2 Solutions691 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
nmcdermaid

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros