Find() / FindNoCase() will give you the position of the period
len() will give you the length of the string
mid() will allow you to access charachters at any place in the string

heres a snippet I wrote to manually parse an xml string:

        <cfset RetailerStart = FindNoCase("<RetailerID>", "#message#") + 12>
        <cfset RetailerEnd = FindNoCase("</RetailerID>", "#message#")>
        <cfset request.RetailerID = Mid("#message#", RetailerStart,
(RetailerEnd - RetailerStart))>

this extracts the string between the 2 tags <retailerid> & </retailerID>

I think in your situation though, you will need to use len() as your known
charachter is in the middle of the sting...

HTH

Dan.

:> -----Original Message-----
:> From: Jordie Fike [mailto:[EMAIL PROTECTED]]
:> Sent: 30 November 2000 16:23
:> To: CF-Talk
:> Subject: a bbs in cf
:> 
:> 
:> first a thank you to those that helped me with my "dates in a sql 
:> statement" problem .. it has taken me close to fruition on 
:> my current pet 
:> project .. but now I've run into another road block
:> 
:> My Immediate Problem:
:> can anyone point me in the proper direction so that I might 
:> be able to 
:> learn what specific functions that are available in CF to 
:> read the contents 
:> of strings/variables? What I need to accomplish is to take 
:> something of the 
:> form
:> 
:> 1234.010203
:> 
:> and be able to break it up into
:> 
:> is_there_a_period = 1
:> var_1 = 1234
:> var_2 = 01
:> var_3 = 02
:> var_4 = 03
:> 
:> when I won't know the length of what's before or after the 
:> period. i.e. 
:> they might be of the form
:> 
:> 12
:> or
:> 1234
:> or
:> 1234.01
:> or
:> 1234.0102
:> etc.
:> 
:> I know I can find the presence of the period with
:> 
:> <CFSET is_there_a_period = ListContains(#sort_key#, ".")>
:> 
:> but I don't know how to find out how many characters there 
:> are to the right 
:> or left of the period if it does exist, and what the value of these 
:> individual characters on either side of the period are.
:> 
:> What I'm Up To:
:> A while back I implemented a BBoard written in Tcl on 
:> OuterBanksBeachGuide.com - it was written by Phillip 
:> Greenspun of MIT. It 
:> has served us well through it's 4 year life span, but lately 
:> I've had 
:> clients asking for something similar on their sites. The 
:> problem with 
:> continuing to use Phillip's board is that it requires an 
:> AOLServer backed 
:> hosting solution and they don't come cheap. So I went 
:> looking for something 
:> written in CF at a comparable price (did I mention that 
:> Phillip's app is 
:> open source) but wasn't able to find much .. so then I get 
:> the bright idea 
:> to try and port Phillip's board from Tcl to CF. I checked 
:> with Phillip to 
:> make sure he was OK with this idea and he assured me that he 
:> is. Although 
:> it is my hope to get this functional on my own .. I would 
:> like to turn this 
:> into an open source project of it's own.
:> 
:> If this is something that you feel you would like to be 
:> involved in or if 
:> you would like a copy once I get it working please feel free 
:> to email me 
:> direct .. just so long as you are charging for your time 
:> installing the 
:> application and not selling the app itself. If anyone knows 
:> that I am 
:> reinventing the wheel and that something like this is 
:> already available, if 
:> you would kindly email me a quick note to point me in the 
:> right direction I 
:> would greatly appreciate it.
:> 
:> Jordie Fike
:> Tech Admin
:> [EMAIL PROTECTED]
:> http://www.outer-banks.nc.us
:> phone - 1.252.441.6698
:> fax - 1.252.480.2259
:>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to