Hi all,
I'm looking for a way to extract all words out of a text-field.
Delimiter: all except alphanumeric + dash + underscore
e.g.
SELECT extr('Hello World. This is a foo_bar test','-_a-zA-Z0-9');
'Hello'
'World'
'This'
'is'
'a'
'foo_bar'
'test'
7 rows
Of course I could do this in the app but in the db it would be much handier.
Is there already such a function ?
TIA
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de