From: | <btober(at)computer(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | SUBSTRING for a regular expression |
Date: | 2004-07-06 00:40:34 |
Message-ID: | 64617.206.53.65.243.1089074434.squirrel@$HOSTNAME |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I can't seem to get right the regular expression for parsing data like
these four sample rows (names and addresses changed to ficticious values)
from a text-type column:
Yolanda Harris, 38, of 40 South Main St., Newtown City, was charged
Sunday with breach of peace and interfering with a police officer.
Allen K. George, 30, of 88 Beverly Court was charged Saturday with
possession of marijuana, third-degree criminal mischief, breach of peace,
evading responsibility, interfering with a police officer, driving with a
suspended license, driving under the influence of drugs or alcohol,
failure to drive right and failure to have proper insurance.
Brain T. Grafton, 18, of 97 Bristol Ave. was charged Sunday with
possession of marijuana, possession of alcohol by a minor and failure to
wear a seat belt.
Brian D. Sptizer Jr., 18, of 20 Walling Ave., Northford, was charged
Sunday with driving under the influence of drugs or alcohol, evading
responsibility and following too closely.
Into separate columns for: name, age, address, charge. For example the
first record would have
name='Yolanda Harris'
age=38
address='40 South Main St., Newtown City'
charge='was charged Sunday with breach of peace and interfering with a
police officer.'
To get the name, for instance, I tried
SELECT SUBSTRING(description FROM '^([:alnum:]*), \d{2}, .*$') FROM
police_log;
or the age value
SELECT SUBSTRING(description FROM '^[:alnum:]*, (\d{2}), .*$') FROM
police_log;
But return values are all NULL. Can anyone give me some RE help, please?
--Berend Tober
From | Date | Subject | |
---|---|---|---|
Next Message | Clodoaldo Pinto Neto | 2004-07-06 01:33:51 | could not access file "$libdir/plpython" when restoring |
Previous Message | B.W.H. van Beest | 2004-07-05 23:27:29 | How to filter on timestamps? |