num = mid(mystr, 4, 3); that says take a string out of the middle of the variable 'mystr', starting at index 4 (the first number), and having length 3 (the number of digits), and assign it to the variable 'num'.
cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 09, 2003 5: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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
