Be seen. Boost your question’s priority for more expert views and faster solutions
Solved
Specific String search Coldfusion
Posted on 2012-12-27
Hi all,
Can someone help me create the following CF Function?
We receive payments from clients but the client number can be anywhere in the description.
The naming convention of the client number is: yyyynnn where yyyy is the year and nnn is a sequence number between 001 and 999. The year can be between 1960 and the current year. There may be other numbers in the description but the client number should be returned only when the above criteria is met.
Thanks in advance.
Errol
Can someone help me create the following CF Function?
We receive payments from clients but the client number can be anywhere in the description.
The naming convention of the client number is: yyyynnn where yyyy is the year and nnn is a sequence number between 001 and 999. The year can be between 1960 and the current year. There may be other numbers in the description but the client number should be returned only when the above criteria is met.
Thanks in advance.
Errol
2
4 Comments
Active today
You'll likely need a regex. You should add that topic to the question tags to attract attention from the right experts. (I'm not a regex guru so I'll leave this to someone more qualified :)
check this..
<cfoutput>
<cfset sourceString="This is a demo string and customer number is not 4537825 but it is 1998893 and not 19989990. Did you got it?" />
Customer number from function is #getCustomerNumber(sourceString)#.
</cfoutput>
<cffunction name="getCustomerNumber" returntype="numeric">
<cfargument name="sourceString" required="true" type="string" />
<cfset startYear = 1960 />
<cfset endYear = dateformat(now(),'yyyy') />
<cfset arrSearch = rematch("[\d]+",sourceString)>
<cfset customerNumber = 0 />
<cfloop from="1" to="#arraylen(arrSearch)#" index="i" step="1">
<cfset cv = arrSearch[i] />
<cfif len(trim(cv)) eq 7>
<cfif ((left(cv,4) gte startYear) and (left(cv,4) lte endYear)) and ((right(cv,3) gt 0) and (right(cv,3) lt 1000))>
<cfset customerNumber = cv />
<cfreturn customerNumber />
</cfif>
</cfif>
</cfloop>
<cfreturn customerNumber />
</cffunction>
Featured Post
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
PROBLEM: How to add your own buttons to the bottom toolbar with paging info ( result count ).
While creating a cfgrid, I ran into an issue where I wanted to embed my own custom buttons where the default ones ( insert / delete / etc… ) are for aes…
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code.
The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…
Suggested Courses
Course of the Month5 days, 23 hours left to enroll
568 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.