• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

XML Illegal Box Type New Record/Line Character

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
jshesek
Asked:
jshesek
  • 2
  • 2
1 Solution
 
Dan CraciunIT ConsultantCommented:
Open the XML with a hex editor (for ex. http://mh-nexus.de/en/hxd/) and see the character code.

HTH,
Dan
0
 
jshesekAuthor Commented:
Sorry to be stupid about this.  Downloaded the program - the attached file shows where the error is.
Capture.PNG
0
 
Dan CraciunIT ConsultantCommented:
OK, then search for 0x0A7F and delete it.
0x usually means hex value, not sure it's the same in ASP.
0
 
jshesekAuthor Commented:
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now