Number from a String

[Fred Beltjens]

I have a string that contains ... (Req 123456) ... somewhere in it. This would be the Subject, text or html body of an email. The number can be 4-7 chars in length... and sometimes the paren's are gone. So as long as it contains 'Req' followed by a space and 4-7 digits... I want the 4-7 digit number... and I need it converted to an integer.

I have read some posts that come close but I am having trouble adapting them... any help would be appreciated

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:21:885
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/21
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:21
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.21
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Matthew Walker]

<cfset match = reFind("Req ([0-9]{4,7})", str, 1, true)>
<cfif match.pos[1]>
        <cfset number = mid(str, match.pos[2], match.len[2])>
<cfelse>
        Not found
</cfif>

-----Original Message-----
From: Fred Beltjens [mailto:fred@...]
Sent: Sunday, 3 July 2005 8:01 a.m.
To: RegEx
Subject: Number from a String

I have a string that contains ... (Req 123456) ... somewhere in it. This
would be the Subject, text or html body of an email. The number can be
4-7 chars in length... and sometimes the paren's are gone. So as long as
it contains 'Req' followed by a space and 4-7 digits... I want the 4-7
digit number... and I need it converted to an integer.

I have read some posts that come close but I am having trouble adapting
them... any help would be appreciated



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase Dreamweaver with Homesite Plus from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=54

Message: http://www.houseoffusion.com/lists.cfm/link=i:21:886
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/21
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:21
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.21
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Fred Beltjens]

Thanks, I will give it a try and let you know!

><cfset match = reFind("Req ([0-9]{4,7})", str, 1, true)>
><cfif match.pos[1]>
> <cfset number = mid(str, match.pos[2], match.len[2])>
><cfelse>
> Not found
></cfif>
>
>-----Original Message-----
>From: Fred Beltjens [mailto:fred@...]
>Sent: Sunday, 3 July 2005 8:01 a.m.
>To: RegEx
>Subject: Number from a String
>
>I have a string that contains ... (Req 123456) ... somewhere in it. This
>would be the Subject, text or html body of an email. The number can be
>4-7 chars in length... and sometimes the paren's are gone. So as long as
>it contains 'Req' followed by a space and 4-7 digits... I want the 4-7
>digit number... and I need it converted to an integer.
>
>I have read some posts that come close but I am having trouble adapting
>them... any help would be appreciated

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase Dreamweaver with Homesite Plus from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=54

Message: http://www.houseoffusion.com/lists.cfm/link=i:21:887
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/21
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:21
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.21
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54