21/06/2010, 19:13
| |||
| |||
| Problemas con expresiones regulares Que tal! Tengo la siguiente cadena 6145356633,6789053456,etc,5678922234,abc,345679797 7 Quisiera saber como le hago para quitar todas las letras de esta cadena! Supongo que ha de ser algo muy sencillo pero no lo he logrado hacer! Les pongo lo que tengo!: html> <body> <cfset txt=form.numbers> <cfset txt=replace(txt ,"[a-z]","","All")> <cfoutput> #txt# </cfoutput> </body> </html> Muchas gracias por su ayuda! |
|
22/06/2010, 12:10
| |||
| |||
| Respuesta: Problemas con expresiones regulares Ya lo resolvi... Muchas gracias! fue asi! <cfset chain = form.numbers> <CFSET listDNC = ""> <CFSET listBadNumbers = ""> <!--- Loop through list of numbers and clean it up ---> <!--- Loop over each record in the list. Separate by comma or new line characters ---> <CFLOOP list="#trim(chain)#" index="phoneNumber" delimiters=",#chr(13)##chr(10)#"> <CFSET tmpPhoneNumber = phoneNumber> <!--- Remove any characters that aren't numbers ---> <CFSET tmpPhoneNumber = ReReplace(tmpPhoneNumber,"[^0-9]","","all")> <!--- If first character is 1 or 0, remove it ---> <CFIF ListFind("0,1",Left(tmpPhoneNumber,1))> <CFSET tmpPhoneNumber = mid(tmpPhoneNumber,2,Len(tmpPhoneNumber))> </CFIF> <!--- If there aren't 10 digits, the number is invalid. Add it to a list to display later. Else, add it to the DNC List ---> <CFIF NOT len(tmpPhoneNumber) IS 10> <!--- Add phone number to list of clean numbers ---> <CFSET listBadNumbers = listAppend(listBadNumbers,phoneNumber) > <CFELSE> <!--- Add phone number to list of clean numbers ---> <CFSET listDNC = listAppend(listDNC,tmpPhoneNumber) > </CFIF> </CFLOOP> <!--- To pass data into database, numbers need to be surrounded by single quotes ---> <CFSET listDNC = ListQualify(listDNC,"'")> |
| Etiquetas: |
