Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.4k views
in Technique[技术] by (71.8m points)

regex - How can I match the last two words in a sentence in PostgreSQL?

Have been trying for a while, to match the last word of a sentence:

select regexp_matches('My name is Harry Potter', '[^ ]+$');

returned {Potter}

to try to match the last two words:

select regexp_matches('My name is Harry Potter', '[^ ]s+[^ ]+$');

failed.

select regexp_matches('My name is Harry Potter', '(.*?)s+(.*?)$');

Did not word as intended either.

Any insights?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

Instead of using REGEXP_MATCHES which returns an array of matches, you may be better off using SUBSTRING which will give you the match as TEXT directly.

Using the correct pattern, as @Abelisto shared, you can do this:

SELECT SUBSTRING('My name is Harry Potter' FROM 'w+W+w+$')

This returns Harry Potter as opposed to {"Harry Potter"}

Per @Hambone's comment, if either of the words at the end contain punctuation, like an apostrophe, you would want to consider using the following pattern:

SELECT SUBSTRING('My name is Danny O''neal' FROM 'S+s+S+$')

The above would correctly return Danny O'neal as opposed to just O'neal


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...