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
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
ASKER
Sorry to be stupid about this. Downloaded the program - the attached file shows where the error is.
Capture.PNG
Capture.PNG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
With this tool I was able to identify the exact character then replace it.
0A = Line Feed / Carraige Return
7F = Undefined
Thanks Dan
0A = Line Feed / Carraige Return
7F = Undefined
Thanks Dan
HTH,
Dan