Postgresql invalid class for [:^punct]

Question

Having read the answer in the Remove all punctuation except apostrophes in R post, I tried to use

'[[:space:]]|[^\/[:^punct:]]'

in REGEXP_REPLACE function, but it gives me

[2201B] ERROR: invalid regular expression: invalid character class

How can I make it work?

What are you trying to match? Any whitespace or any punctuation but `/`? — Wiktor Stribiżew, Mar 25 '19 at 11:57
I'm trying to match a string that contains alphanumeric plus danish characters plus / , the regex is used in REGEXP_REPLACE(ref,'[[:space:]]|[^\/[:^punct:]]','','g'); — Med Amine, Mar 25 '19 at 11:58

score 1 · Accepted Answer · answered Mar 25 '19 at 12:00

1

The question you link to is tagged with r, where stringr library uses ICU regex flavor that supports POSIX character classes in its own way, not necessarily POSIX compatible.

To match any whitespace or any punctuation but / you may use

[^/[:alnum:]]

It matches any char that is not alphanumeric (and that means it is either a whitespace or punctuation) and not a / char.

answered Mar 25 '19 at 12:00

Wiktor Stribiżew

607,720
39
448
563

I also need to include danish characters – Med Amine Mar 25 '19 at 12:04
@MedAmine Does it mean you want to remove Danish characters? Do you have a list of those you want to remove? Just put them after `/`. – Wiktor Stribiżew Mar 25 '19 at 12:05
@MedAmine FYI, you may use `'[^/A-Z0-9]+'` if you want to remove all letters but ASCII letters & digits & `/` char. – Wiktor Stribiżew Mar 25 '19 at 12:14

Postgresql invalid class for [:^punct]

1 Answers1