Sorry. I was going with your sample data. They all only had 2 dashes. This
will work as well.
<cfset tmp = arraynew(1)>
<cfset tmp[1] = "Adi5RT-F-l-o-12Roy-3(Lg)">
<cfset tmp[2] = "Adi5RT-FSU2R-ed-2(Md)">
<cfset tmp[3] = "Adi5RT-FSU---2Red-3(Lg)">
<cfset tmp[4] = "Adi5RT-FSU2-Red-4(XL)">
<cfset tmp[5] = "Adi5RT-F------S-----U2Red-5(2X)">
<cfset tmp[6] = "Adi5RT-FSU-3Wht-2(Md)">
<cfset tmp[7] = "Adi5RTFSU3Wht-3(Lg)">
<cfloop from="1" to="#arraylen(tmp)#" index="i">
<cfset var1 = listdeleteat(tmp[i], listlen(tmp[i], "-"), "-")>
<cfset tmp[i] = var1 & "_" & listlast(tmp[i], "-")>
</cfloop>
<cfdump var="#tmp#">
I'm sure there's a cleaner regex for it but like I said... I suck at those.
I was surprised to get the last one to work at all to be honest with you.
As for updating all the records... can't you just select them, loop them,
and update them? This isnt something you are going to do redundantly is it?
Seems to be more of a one-time clean up script?
So instead of the array, it would be your query results.
-----Original Message-----
From: Ken [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 03, 2005 8:41 PM
To: CF-Talk
Subject: Re: String replace
Also, in your code, you are presuming there will always be 2 dashes in
the string. The code won't work if there are 3 dashes, Like this:
Adi5RT-Flo12-Roy-3(Lg). Can this code be made flexible?
On 8/3/05, Ewok <[EMAIL PROTECTED]> wrote:
> This seems to work as well ( to my surprise since I suck at regex's)
>
>
> <cfset tmp = arraynew(1)>
>
> <cfset tmp[1] = "Adi5RT-Flo12Roy-3(Lg)">
> <cfset tmp[2] = "Adi5RT-FSU2Red-2(Md)">
> <cfset tmp[3] = "Adi5RT-FSU2Red-3(Lg)">
> <cfset tmp[4] = "Adi5RT-FSU2Red-4(XL)">
> <cfset tmp[5] = "Adi5RT-FSU2Red-5(2X)">
> <cfset tmp[6] = "Adi5RT-FSU3Wht-2(Md)">
> <cfset tmp[7] = "Adi5RT-FSU3Wht-3(Lg)">
>
> <cfloop from="1" to="#arraylen(tmp)#" index="i">
> <cfset tmp[i] = rereplace(tmp[i], "(.*?-.*?)-(.*)", "\1_\2")>
> </cfloop>
>
> <cfdump var="#tmp#">
>
>
>
> -----Original Message-----
> From: Ken [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 03, 2005 8:05 PM
> To: CF-Talk
> Subject: String replace
>
> Hi I have a db column as displayed below. I want to replace the last
> "-" with a underscore "_". Note: I don't want to replace all the
> dashes. Just the last one. It should look like this:
> Adi5RT-Flo12Roy_3(Lg). Any ideas?
>
> Adi5RT-Flo12Roy-3(Lg)
> Adi5RT-FSU2Red-2(Md)
> Adi5RT-FSU2Red-3(Lg)
> Adi5RT-FSU2Red-4(XL)
> Adi5RT-FSU2Red-5(2X)
> Adi5RT-FSU3Wht-2(Md)
> Adi5RT-FSU3Wht-3(Lg)
>
> Thanks,
> Kenny
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213683
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
