REGEX PostgreSQL Replace

​Working with MARC format, remove pipes and letters.


|aShakespeare, William,|d1564-1616.


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


Shakespeare, William, 1564-1616.

Tsohost UK Web Host Review & Promo Discount Code
Ubuntu Remotely Connect to MySQL Database


No comments made yet. Be the first to submit a comment
Already Registered? Login Here
July 15, 2020

Captcha Image

Latest Comments

Guest - 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!!?
Guest - Johmny Invisible Mouse Cursor Ubuntu & Synergy
September 2, 2015
Glad I was ble to help!
Guest - Kristian Falk Invisible Mouse Cursor Ubuntu & Synergy
September 1, 2015
Thank you for this! Had the exact same problem. I almost went crazy.