It's finding the POSITION within the string of the first digit.
ed
----------------------------------------------------------------------
Ed Szwedo
Web Development Team Lead
CSC
E-mail: [EMAIL PROTECTED]
919-541-3955 (Voice)
919-685-3395 (Fax)
Mischa
Uppelschoten ext
10 To
<Mischa.Uppelsch Web Site <[email protected]>
[EMAIL PROTECTED] cc
m>
Sent by: Subject
[EMAIL PROTECTED] re[2]: [ACFUG Discuss] Finding
numbers in strings
09/25/2007 11:40
AM
Please respond
to
[EMAIL PROTECTED]
.org
Thanks Ben!
I'm not a RE wiz, so I'm not sure I understand why
REFindNoCase("[0-9]", "ATTN: JOE SMITH PO## 72274");
results in "22"... ?
: REFindNoCase("[0-9]", MyString)
: You may have to play around with the regular expression some to get
exactly
: what you want, but that should get you started.
: Benjamin Bloodworth
: [EMAIL PROTECTED]
: 850.702.0052
: -----Original Message-----
: From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mischa
: Uppelschoten ext 10
: Sent: Tuesday, September 25, 2007 11:20 AM
: To: Web Site
: Subject: [ACFUG Discuss] Finding numbers in strings
: I thought I once saw a function in CF that would find a numeric part
: anywhere in a string, but I can't find it anymore (or was I dreaming?)
: Anyway, here are some sample strings I need to parse:
: "ATTN: JOE SMITH PO# 72274"
: "3150 holcomb bridge road"
: " PO# 72049"
: " 6311 COURT ST."
: "PO's 72993, 73252,73211"
: What I'd like to find in a string:
: - does the string contain a number larger than 72000 and smaller or
equal to
: 999999?
: - if yes, does the string contain the letters "po"
: - if yes, return the string from "po" until the end
: - if no, return the string
: Background: sometimes our customers put our Purchase Order number(s)
(which
: range between 72000 and 999999) in the address fields of a UPS label
and
: it's hard to find when the bill comes, so any parsing I can do here,
will
: help our AP folks a lot.
: Thanks!
: /m
: -------------------------------------------------------------
: Annual Sponsor FigLeaf Software - http://www.figleaf.com
: To unsubscribe from this list, manage your profile @
: http://www.acfug.org?fa=gin.edituserform
: For more info, see http://www.acfug.org/mailinglists
: Archive @ http://www.mail-archive.com/discussion%40acfug.org/
: List hosted by http://www.fusionlink.com
: -------------------------------------------------------------
: No virus found in this incoming message.
: Checked by AVG Free Edition.
: Version: 7.5.488 / Virus Database: 269.13.30/1030 - Release Date:
9/25/2007
: 8:02 AM
:
: No virus found in this outgoing message.
: Checked by AVG Free Edition.
: Version: 7.5.488 / Virus Database: 269.13.30/1030 - Release Date:
9/25/2007
: 8:02 AM
:
: -------------------------------------------------------------
: Annual Sponsor FigLeaf Software - http://www.figleaf.com
: To unsubscribe from this list, manage your profile @
: http://www.acfug.org?fa=login.edituserform
: For more info, see http://www.acfug.org/mailinglists
: Archive @ http://www.mail-archive.com/discussion%40acfug.org/
: List hosted by http://www.fusionlink.com
: -------------------------------------------------------------
Mischa Uppelschoten
The Banker's Exchange, LLC.
2020 Hills Avenue NW
Atlanta, GA 30318
Phone: (404) 605-0100 ext. 10
Fax: (404) 355-7930
Web: www.BankersX.com
Follow this link for Instant Web Chat:
http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN
---------- Original Message ----------
FROM: "Benjamin Bloodworth" <[EMAIL PROTECTED]>
TO: <[email protected]>
DATE: Tue, 25 Sep 2007 11:23:45 -0400
SUBJECT: RE: [ACFUG Discuss] Finding numbers in strings
REFindNoCase("[0-9]", MyString)
You may have to play around with the regular expression some to get
exactly
what you want, but that should get you started.
Benjamin Bloodworth
[EMAIL PROTECTED]
850.702.0052
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mischa
Uppelschoten ext 10
Sent: Tuesday, September 25, 2007 11:20 AM
To: Web Site
Subject: [ACFUG Discuss] Finding numbers in strings
I thought I once saw a function in CF that would find a numeric part
anywhere in a string, but I can't find it anymore (or was I dreaming?)
Anyway, here are some sample strings I need to parse:
"ATTN: JOE SMITH PO# 72274"
"3150 holcomb bridge road"
" PO# 72049"
" 6311 COURT ST."
"PO's 72993, 73252,73211"
What I'd like to find in a string:
- does the string contain a number larger than 72000 and smaller or
equal to
999999?
- if yes, does the string contain the letters "po"
- if yes, return the string from "po" until the end
- if no, return the string
Background: sometimes our customers put our Purchase Order number(s)
(which
range between 72000 and 999999) in the address fields of a UPS label and
it's hard to find when the bill comes, so any parsing I can do here,
will
help our AP folks a lot.
Thanks!
/m
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=gin.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.30/1030 - Release Date:
9/25/2007
8:02 AM
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.30/1030 - Release Date:
9/25/2007
8:02 AM
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
