insert character in text

[twcman]

I have a list of times (100,200,300, etc.) that come from a database table. On output, I would like to insert a : before the last two digits (1:00,2:00, etc).

Could some one point me in the right direction?

The only dumb questions are the ones that are never asked

 

[Sarky78]

you can use the insert command. this will allow you to insert a substring anywhere into another string.

<CFSET dbLength = (Len(dbField) - 2)>

<CFSET out = Insert(&quot;:&quot;, dbField, dbLength)>

<cfoutput>
#out#
</cfoutput>

Hope this works !!

 

[tleish]

You can use a regular expression

<cfset vList = &quot;100,200,300&quot;>
<cfset vNewList = ReReplace(variables.vList, &quot;(

[

[

:digit:

]

]

)(

[

[

:digit:

]

]

{2})&quot;, &quot;\1:\2&quot;, &quot;ALL&quot;)> - tleish