Try this.. (straight outta the CF documentation more or less...) <cfset myString = "SSS444BBB">
Your original string: <CFOUTPUT><strong>#myString#</strong></CFOUTPUT><br><br> Your changed string, showing only the <CFOUTPUT><strong>3</strong></CFOUTPUT> middle characters: <CFOUTPUT><strong>#Mid(myString, 4, 3)#</strong></CFOUTPUT> -- Bruce H. Beinert p.808-637-0727<>m.917-627-4035 Web Development and Consulting: http://www.siliconmaui.com Weblog: http://www.bruceandwende.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 2:36 PM To: CF-Talk Subject: String help Hello, I'm outputing a query and have a part number value. The part number value is syntacically the same, (SSS444BBB) The first part of the part number is three letters, then three numbers. I want to extract the three numbers from this part number. Any suggestions? Thanks D ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
