Found the function I needed. FindOccurrences() on cflib.org
-----Original Message-----
From: James Johnson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 3:03 PM
To: CF-Talk
Subject: Escaping the # symbol - Solved. New Question
All,
With help from the MM CF Forums I got the answer. For testing I was
typing a literal string, not working with values direct from the DB.
Somehow that caused the problem. Here's the code that works (Remember
I'm trying to split this value into two new ones)
<cfquery name="test" datasource="GTS_Dental">
SELECT "1" <!--- this is the name of the field after the Excel
SS is imported into Access
AS Products
FROM Acrylics_Custom_Tray_Materials
WHERE ID=25
</cfquery>
<cfset Variables.products = test.Products>
<cfset Variables.ProdNameCount = Find("##",Variables.Products) -1>
<cfset Variables.ProdNumCount = Len(Variables.Products) -
Variables.ProdNameCount>
<cfset Variables.NewProd =
Trim(Left(Variables.products,Variables.ProdNameCount))>
<cfset Variables.NewProdNum =
Trim(Right(Variables.products,(Variables.ProdNumCount -1)))>
My new question is this. Occasionally the "Products" value will have a #
that I need to keep, so I'll need to split on the last # in the string.
Looking through the CF String Manipulation functions, I don't see
anything that will return a count of a particular character. I haven't
found any on cflib.org as well.
How could I find how many of a certain characters are in a string?
Thanks,
James
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
