XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Cynthia van BovenSubject: Can't encode 0x4 in text
Author: Cynthia van Boven
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


DocumentTest_1000.csv
Extract 1000 records to find wrong char

Postnext
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.

Posttop
Cynthia van BovenSubject: Can't encode 0x4 in text
Author: Cynthia van Boven
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 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.