[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

XML Illegal Box Type New Record/Line Character

Posted on 2014-01-20
4
Medium Priority
?
304 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 35

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 2

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 35

Accepted Solution

by:
Dan Craciun earned 2000 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 2

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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

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…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

656 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