That should be the NULL character. Try adding #chr(0)# to your regex. On 11/6/06, Josh Nathanson <[EMAIL PROTECTED]> wrote: > Thanks Rob. It's data from a shopping cart orders database, the data is not > captured as XML - it would be kind of overkill to wrap the several dozen > incoming fields in XMLFormat or CDATA blocks, since the XML generating part > of the cart is a small part of the overall application, and this control > character problem only pops up once every couple of months. > > Plus, I've found XMLFormat and CDATA to throw errors with control > characters - can't have that when someone is trying to place an order! > > I just want to be able to clean the data on the way out of the database. I > don't get why I can't get at that Unicode 0x0 character in the same way I > can get at Unicode 0x5, 0xA, 0xF or whatever. > > -- Josh > > > ----- Original Message ----- > From: "Rob Wilkerson" <[EMAIL PROTECTED]> > To: "CF-Talk" <cf-talk@houseoffusion.com> > Sent: Monday, November 06, 2006 4:07 PM > Subject: Re: Cleaning XML - Unicode 0x0 > > > > On 11/6/06, Josh Nathanson <[EMAIL PROTECTED]> wrote: > >> > Don't know whether it'll work for you, but the regex I've used > >> > successfully is REReplace ( mystring, '>\s*<', '><', 'ALL' ). It > >> > clears any whitespace between tags themselves. > >> > >> No dice, apparently whitespace is not the problem...anyone else? > > > > What kind of data does your XML contain? Are you properly capturing > > that data using either <![CDATA[]]> blocks or XMLFormat()? > > > > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259395 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4