Hi, I have a text file of 100,000 plus phone numbers that I need to change formatting and export to a clean list. There is an unusual hidden character that doesn't appear when pasting. Here is a screen shot http://www.aceligent.com/post/hidden.html
The list is compiled in this manner, 'X' is supplemented for where the hidden character is: 212,2000876x212,2002686x212,2005799x212,2007697x212,2010062x212,2010087x212, 2010112x212,2010192x212,2010237x212,2010306x212,2010326x212,2010710x212,2010 714x212,2010740x212,2010754x212,2010800x212,2010978x212,2011063x212,2011065x I need to process the list as a batch. How would I adapt this to clean and count a 10 number sequence; add a coma; and repeat on new line? Then export as a text file. <cfset form.phone = "#form.phoneinput#"> <cfset cleanPhone = ReReplace(form.phone, "[^0-9]", "", "ALL")> <cfoutput>#cleanPhone#</cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
