This worked for me :)
<cfset string="Department Summary by Employee 10/27/2010 - 10/27/2010"
<cfoutput>#ListGetAt(string, 5, ' ')#</cfoutput>
On Wed, Jan 26, 2011 at 2:01 PM, Monique Boea <moniqueb...@gmail.com> wrote:
> This give me the value of 32
>
>
> <cfset string="Department Summary by Employee 10/27/2010 - 10/27/2010">
> <cfset dates=REFind("[0-1][0-9]/[0-3][0-9]/[0-9]{4}", string)>
> <cfoutput>#dates#</cfoutput>
>
>
>
>
> On Wed, Jan 26, 2011 at 1:54 PM, Ben Forta <b...@forta.com> wrote:
>
>>
>> Assuming that the dates are always in mm/dd/yyyy format, I'd use a regular
>> expression, something like this:
>>
>> <cfset string="*Department Summary by Employee 10/27/2010 - 10/27/2010*">
>> <cfset dates=REFind("[0-1][0-9]/[0-3][0-9]/[0-9]{4}", string)>
>>
>> <disclaimer>
>> Code written on the fly with no testing ;-)
>> </disclaimer>
>>
>> Dates will then be an array, and in your example dates[1] will be the
>> start
>> date and dates[2] the second date.
>>
>> --- Ben
>>
>>
>> -----Original Message-----
>> From: Monique Boea [mailto:moniqueb...@gmail.com]
>> Sent: Wednesday, January 26, 2011 1:42 PM
>> To: cf-talk
>> Subject: Extracting a date from a string
>>
>>
>> Hello All.
>>
>> How would you go about extracting the date from this string:
>>
>> *Department Summary by Employee 10/27/2010 - 10/27/2010*
>>
>>
>>
>>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341417
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
