Unicode regexp_replace in PostgreSQL [duplicate]

Question

Possible Duplicate:
regexp_replace Unicode in PostgreSQL

How to regexp_replace for Unicode in PostgreSQL

i read this http://www.regular-expressions.info/unicode.html

select regexp_replace('s4y8sds', '\\p{Number}', '')

or

select regexp_replace('s4y8sds', '\\p{N}', '')

but not work

Thanks

Community · Accepted Answer · 2017-05-23 11:47:55Z

0

As far as I know Postgres does not understand \p{} (as in the article you have linked). See the docs here http://www.postgresql.org/docs/9.0/static/functions-matching.html

According to this answer, internationalized regular expression in postgresql Unicode is not supported by Postgres in this way.

In case you want to replace numbers with empty string, you can do it like this:

select regexp_replace('s١4y8sd½s', '[0-9١٢٣¼½¾]', '', 'g');
 regexp_replace 
----------------
 sysds

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered Aug 9, 2011 at 13:00

bpgergo

16.1k5 gold badges48 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Thessa Over a year ago

I'm working with Unicode. so if i have number in other format like Roman(Ⅱ Ⅲ Ⅳ), Arabic(١ ٢ ٣ ٤) and Other(¼ ½ ¾). regexp_replace('s4y8sds', E'\\d+', '', 'g') cant work

bpgergo Over a year ago

@Thessa, thanks for clarifying your question. I'll update the answer in a minute.

Collectives™ on Stack Overflow

Unicode regexp_replace in PostgreSQL [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related