Have you tried Chr(244) as the delimiter? On Thu, Sep 6, 2012 at 1:36 PM, Roger Anthony <[email protected]> wrote:
> > I've got a MySQL database that has a rather long string in it (HL7 to be > precise) that has a pilcrow ( Å ) as the last character of each row. I'm > trying to do a ListToArray and get each row into an array element using the > pilcrow as the delimiter but I can't seem to get it figured out. > > <alt>+182 doesn't work, the symbol itself doesn't work, escaping them > doesn't work... I'm at a loss. > > Anyone have any ideas? Thanks! > > -- > > Roger Anthony > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
