Delimiting a pilcrow

2012-09-06 Thread Roger Anthony

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.

+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:352435
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Delimiting a pilcrow

2012-09-06 Thread Alan Rother

Have you tried Chr(244) as the delimiter?

On Thu, Sep 6, 2012 at 1:36 PM, Roger Anthony  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.
>
> +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