Solved

XML Illegal Box Type New Record/Line Character

Posted on 2014-01-20
4
291 Views
Last Modified: 2014-01-20
Hello,

I'm reading in an XML file into SQL.  Next it goes to a flat csv file.  
There's an illegal character that is causing it not to write the record correctly to the csv file.  The character starts a new record.  The character does go into the SQL record.

Can you help me determine what the character is?  

It looks like the attached picture.  And it causes a new record to start.  The picture is from the original XML file.  

Using asp.net vb
Capture.PNG
0
Comment
Question by:jshesek
  • 2
  • 2
4 Comments
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 39794226
Open the XML with a hex editor (for ex. http://mh-nexus.de/en/hxd/) and see the character code.

HTH,
Dan
0
 
LVL 1

Author Comment

by:jshesek
ID: 39794249
Sorry to be stupid about this.  Downloaded the program - the attached file shows where the error is.
Capture.PNG
0
 
LVL 34

Accepted Solution

by:
Dan Craciun earned 500 total points
ID: 39794261
OK, then search for 0x0A7F and delete it.
0x usually means hex value, not sure it's the same in ASP.
0
 
LVL 1

Author Closing Comment

by:jshesek
ID: 39794344
With this tool I was able to identify the exact character then replace it.  
0A = Line Feed / Carraige Return
7F = Undefined


Thanks Dan
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Loop not working 29 48
error on the asp.net page 1 33
Runtime Exceptions when trying to submit data 28 37
designing in object programming 12 52
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now