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?
Re: How to clean up phone-numbers with regex? |
Список | 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 по дате отправления: