Repository navigation
regexp_match( ) do not work on PostgreSQL 11 for these cases #10
Description
SELECT crime_id,
regexp_match(original_text, '(?:Sq.|Plz.|Dr.|Ter.|Rd.)\n(\w+ \w+|\w+)\n')
AS city
FROM crime_reports;
SELECT crime_id,
regexp_match(original_text, 'hrs.\n(\d+ .+(?:Sq.|Plz.|Dr.|Ter.|Rd.))') AS street
FROM crime_reports;
SELECT crime_id,
regexp_match(original_text, '\n(?:\w+ \w+|\w+)\n(.*):') AS crime_type
FROM crime_reports;
Activity
anthonydb commentedon Nov 3, 2018
Hi, thanks for reaching out. I just tried these on PostgreSQL 11 on macOS (Postgres.app and pgAdmin 3.5). They worked fine. Haven't tested on Windows or Linux yet.
Which operating system are you using?
Also, did you by any chance open crime_reports.csv in Excel or another text editor before importing? Sometimes, doing so might change the file encoding.
jhl8917 commentedon Nov 4, 2018
Dear Mr. DeBararros,
Thank you for your quick reply. I ran the codes on Windows and pgAdmin 4. I will try to run again with untouched crime_reports.csv. Thanks again,
Johnathan Liu
jhl8917 commentedon Nov 4, 2018
Dear Mr. DeBararros,
After I copy new crime_reports.csv to my working directory, these codes work now.
Thank you for your excellent book.
Best,
Johnathan Liu
anthonydb commentedon Nov 6, 2018
Glad to hear that all worked out. Thank you for reading!