RE: String Manipulation Fun

2008-02-05 Thread Bobby Hartsfield
(if you can guarantee no other dollar symbols) val(rereplace(theXMLdata, ".*?\$(.*?)", "\1")) ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 05, 2008 3:59 PM To:

RE: String Manipulation Fun

2008-02-05 Thread Che Vilnonis
Thanks. Did the trick... -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 05, 2008 4:06 PM To: CF-Talk Subject: RE: String Manipulation Fun Do a ListLen(str, "$") to see if the second element is present first. Adrian http://www.adrianl

RE: String Manipulation Fun

2008-02-05 Thread Brad Wood
> There's probably a better way of doing this though... There is-- but I think it involves atomic data. :) ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://a

RE: String Manipulation Fun

2008-02-05 Thread Kevin Aebig
nonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 05, 2008 2:59 PM To: CF-Talk Subject: String Manipulation Fun Take the following xml string value: 1969 Chevrolet Camaro - Windsor, ON N8W 5J1 - $44900 I use the following code to extract and set the price: Sometimes though

RE: String Manipulation Fun

2008-02-05 Thread Adrian Lynch
Do a ListLen(str, "$") to see if the second element is present first. Adrian http://www.adrianlynch.co.uk/ -Original Message- From: Che Vilnonis Sent: 05 February 2008 20:59 To: CF-Talk Subject: String Manipulation Fun Take the following xml string value: 1969 Chevro

String Manipulation Fun

2008-02-05 Thread Che Vilnonis
Take the following xml string value: 1969 Chevrolet Camaro - Windsor, ON N8W 5J1 - $44900 I use the following code to extract and set the price: Sometimes though, the xml data is incomplete and looks like this: 1969 Chevrolet Camaro - Windsor, ON N8W 5J1 - $ My curren