How to clean up phone-numbers with regex?

Поиск
Список
Период
Сортировка
От Andreas
Тема How to clean up phone-numbers with regex?
Дата
Msg-id 5379C6C1.5020904@gmx.net
обсуждение исходный текст
Ответы Re: How to clean up phone-numbers with regex?  (Rob Sargent <robjsargent@gmail.com>)
Re: How to clean up phone-numbers with regex?  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-sql
<font face="Arial">Hi<br /><br /> I need to clean up phone-numbers. Somehow I got a Excel list that has weird graphical
characterstrailing some of the entries.</font><br /><font face="Arial"><font face="Arial">My DB is UTF8 so it would
storethis mess but I don<small>'t like to import it in the first place.<br /><br /> OK, I know how to read the stuff
intoa temporary table to clean it up before the actual import.<br /></small></font>How can I do an update on the column
thatdeletes every char that is not in a given set of chars like '+- 0123456/()'?<br /><br /><small></small><br />
Secondbut similar question:<br /> How can I select records that have fields that contain characters not included in a
givenalphabet?<br /> E.G. find fields that contain some char not in 0-9,a-z,A-Z, +-()/?<br /><br /><br /> regards<br />
Andreas<br/></font> 

В списке pgsql-sql по дате отправления:

Предыдущее
От: James Cloos
Дата:
Сообщение: Re: matching column of regexps
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: How to clean up phone-numbers with regex?