initial : 1,2,3,4,5,6,10,11,12,13,14,20,25,30,31,32,33,50
desired : 1-6,10-14,20,25,30-33,50
computed: 1-6,10-14,20-20,25-25,50
^^ ^^ ^^
The code in my initial post works correctly, and is reposted (with slight
optimizations) below:
<!--- supplied list --->
<cfset var1 = "1,2,3,4,5,6,10,11,12,13,14,20,25,30,31,32,33,50" />
<!--- compute the 'ranged' list --->
<cfset last = "" />
<cfset var2 = "" />
<cfset startedRange = false />
<cfloop list="#var1#" index="curr">
<cfif last EQ curr - 1>
<cfset startedRange = true />
<cfelseif startedRange>
<cfset var2 = var2 & "-" & last />
<cfset startedRange = false />
</cfif>
<cfif NOT startedRange>
<cfset var2 = listAppend(var2, curr) />
</cfif>
<cfset last = curr />
</cfloop>
Cheers,
barneyb
> -----Original Message-----
> From: Steve Nelson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 19, 2004 11:50 AM
> To: CF-Talk
> Subject: RE: **UPDATE** Arrange sequential selections into
> ranges how to???
>
> <cfset var1 = "1,2,3,4,5,6,10,11,12,13,14,20,25,30,31,32,33,50">
>
>
>
> <cfset var2="">
>
> <cfset lastitem=listfirst(var1)>
>
> <cfset groupstart=lastitem>
>
> <cfloop list="#var1#" index="item">
>
> <cfif item gt lastitem+1>
>
> <cfif item is listlast(var1)>
>
> <cfset newgroup=item>
>
> <cfelse>
>
> <cfset
> newgroup="#groupstart#-#lastitem#">
>
> </cfif>
>
> <cfset var2=listappend(var2,newgroup)>
>
> <cfset groupstart=item>
>
> </cfif>
>
> <cfset lastitem=item>
>
> </cfloop>
>
>
>
> <cfoutput>#var2#</cfoutput>
>
>
>
> I left out the lastitem=item
>
>
>
> Steve
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
