REGEX PostgreSQL Replace

​Working with MARC format, remove pipes and letters.


Before;

|aShakespeare, William,|d1564-1616.


Regex;

REGEXP_REPLACE(|aShakespeare, William,|d1564-1616.,'\|.',' ','g')


After;

Shakespeare, William, 1564-1616.

Rate this blog entry:
Ubuntu Remotely Connect to MySQL Database
Tsohost UK Web Host Review & Promo Discount Code

Comments

 
No comments yet

Latest Comments

Susan Hermiston Virtual Hosts
October 7, 2015
Wow 747 just blew me away. Sorry not a tech person at all!! But I still love you!! Rock on!!?
Johmny Invisible Mouse Cursor Ubuntu & Synergy
September 2, 2015
Glad I was ble to help!
Kristian Falk Invisible Mouse Cursor Ubuntu & Synergy
September 1, 2015
Thank you for this! Had the exact same problem. I almost went crazy.