SSDN - Can't encode 0x4 in text

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

(Deleted User)

Subject: Can't encode 0x4 in text
Author: (Deleted User)
Date: 29 Oct 2008 03:53 PM
Originally Posted: 29 Oct 2008 03:43 PM

I am trying to convert attached file from csv to xml, but get the error "Can't encode 0x4 in text". If I strip the file to 3 lines or to 50 I don't get the message, so it must be some invalid character which is not recognised by the input encoding, but what's the easiest way to find the problem giving character in this file of 12000 records?

Best regards,

Cynthia

Test_1000.csv
Extract 1000 records to find wrong char

Minollo I.

Subject: Can't encode 0x4 in text
Author: Minollo I.
Date: 29 Oct 2008 04:19 PM

One way is to use regular expressions.
Open the file inside Stylus Studio as if it was an XML file; then do Ctrl+F, check the "regular expression" checkbox and enter \x04 as the search expression.

(Deleted User)

Subject: Can't encode 0x4 in text
Author: (Deleted User)
Date: 29 Oct 2008 04:32 PM

Thank you, that does the trick!

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.