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" <[email protected]> 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:259387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
